Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PK Index V Additional Column INdex
I'd probably take a look at the number of IO (either physical or
logical) with both indexes instead, with autotrace turned on. It might
for example be that one of the indexes has a very good clustering
factor, while the other has not. Or one of the indexes has more levels
than the other (meaning that more IO is required to reach the leaf
blocks).
Just my 2 cents
Daniel Received on Thu May 26 2005 - 21:26:41 CDT