Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index skip scan
Oradba Linux wrote:
> Does this mean that you can concatenate many indices into one and
still get
> the same/better performance?
No.
> Any caveats to watch out for?
The first caveat you need to 'watch out for' is your misunderstanding of what index skip scan actually does:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/optimops.htm#51553
Please read this to better understand what is happening and why. David Fitzjarrell Received on Fri Jan 14 2005 - 11:42:36 CST