Re: Q: Oracle sqlplus way to capture all duplications and removal.

vslabs_at_onwe.co.za (Billy Verreynne) wrote in message news:<1a75df45.0309110101.79e9ffb9_at_posting.google.com>...
> colocoloc_at_yahoo.com (ColoC) wrote i
>
> >

Sorry, I mixed index() with index_ffs(). Now here are the comparison:

/*+ INDEX_FFS(tab,ind_field) */
Elapsed: 00:00:07.94

/*+ INDEX(tab) */
Elapsed: 00:00:19.81

/* no hint */
Elapsed: 00:00:08.14

So the INDEX_FFS() may not seem to help much (all the above were done in a short period of time, while other system load should be the same).

ColoC Received on Thu Sep 11 2003 - 09:52:18 CDT