Re: FULL TABLE SCANS...

On Sun, 09 Nov 1997 22:48:49 -0500, Michael Rosadino <mrosadino_at_connico.net> wrote:

>Here's a quick question which I know probably has a very long answer.

<SNIP>

>numerous methods to avoid "FULL TABLE SCANS" such as Optimization hints,
>the use of EXIST and UNION operators, and different orders within my
>WHERE & FROM clauses [tips taken from the orange O'Reilly book], but
>I know I must be missing something. By the way, the databases is fully
> indexed as well, at least for the fields which I use to establish
>joins in my WHERE clause. So here's the question:
>
> WHAT IS THE MAGIC METHOD???
>
>Any help you can provide would be great.

An example query and a list of the available indexes would prove helpful.

Jared Still
Oracle DBA and Part Time Perl Evangelist ;) jkstill_at_bcbso.com - work
jkstill_at_teleport.com - home Received on Tue Nov 11 1997 - 00:00:00 CST