Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: O9i: How to create a matching index to a given query
sybrandb schrieb am 02.04.2007 in
<1175500079.842304.118110_at_l77g2000hsb.googlegroups.com>:
> On Apr 2, 9:35 am, Andreas Mosmann <mosm..._at_expires-30-04-2007.news- > group.org> wrote:
> 1 read the explain plan, identify the driving table, and make sure the > driving table is correct (ie assuming the driving table is not a look > up table) and returns the smallest number of records. So no trial and > error involved, but 'know thy application'Which is the driving table of my query? How can I tell the CBO what driving table he has to use? Why should a driving table not be a lookup table (if I understand it correct)? Is it possible to explain with the example above?
> 2 Primarily on 'know thy application' and reading documentation, and > by avoiding putting everything on 1 single disk. To read Oracle documentation row by row I would need years. Is there a place I can read (my English is not the very best)?
> 3 The concept outlined above is explained in great detail in the 'SQL > Tuning book' by Dan Tow, published by O'Reilly. I bought it right now. Thanks.
> The books by Cary Millsap, Jonathan Lewis, and Tom Kyte have been > recommended here so many times, I won't recommend them further. Anyone > here can find their details by searching Google.searching google is a fine thing but without useful keywords it is more interesting reading yellow pages.
> -- > Sybrand Bakker > Senior Oracle DBA
Thank you very much
Andreas Mosmann
-- wenn email, dann AndreasMosmann <bei> web <punkt> deReceived on Mon Apr 02 2007 - 04:57:31 CDT