Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help me tune this query (please).
Andy; a 5-second analysis (sorry, but no more free time, I'm late already!) seems to indicate that your indexes (ORG_PK and ORG_NDX_5) both have party_type as a second member of a concatenated index. Oracle WILL NOT use the index if you reference a second member without using the first member. So, either use ORG_ID as part of the where below, or (re)create an index with party_type first (or only). Received on Tue Nov 18 1997 - 00:00:00 CST