From: jkstill@teleport.com Subject: Re: FULL TABLE SCANS... Date: 1997/11/11 Message-ID: <3467e208.783190@news.teleport.com>#1/1 References: <34668421.3162@connico.net> Organization: Teleport - Portland's Public Access (503) 220-1016 Newsgroups: comp.databases.oracle.misc,comp.database.oracle.tools,comp.databases.oracle On Sun, 09 Nov 1997 22:48:49 -0500, Michael Rosadino wrote: >Here's a quick question which I know probably has a very long answer. >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@bcbso.com - work jkstill@teleport.com - home