Notes in-line Regards
Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html ____UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html ----- Original Message ----- > From: "Kaing, Leng" <[EMAIL PROTECTED]> > > Brilliant example. Thanks very much for this. (And yes, I meant the first 15th for each index, not the first 15th for the entire database!) > I had to ask, as once upon a time people used to say that Oracle was limited to using a maximum of 5 indexes in any one query. (Misunderstanding the manuals comments about the maximum number of indexes that could be used in the AND-EQUAL path of a single table, I believe). > And yes, I do think that 15 indexes is a bit excessive but I can't help it at the moment (3rd party, packaged application...) It's not necessarily wrong - just something to be suspicious of when you start from cold at a site. > > Does this mean that I'm reading another myth? Couldn't confirm it on metalink. I've never seen anything like it claimed before. Maybe it's something to do with the fact that the manuals list 15 rankings in the RBO ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).