Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: redundant indices?
ryan wrote:
>Hi All,
>I've been reviewing some indices in a database I've recently become
>the DBA for, and I need some advice. On one table, we have the
>following indices (the names have been changed to protect the
>innocent):
>
>index1( AAA, XXX, YYY );
>index2( BBB, XXX, YYY );
>index3( XXX, YYY, ZZZ );
>index4( CCC, YYY, ZZZ );
>index5( DDD, YYY, ZZZ );
>
>I'm a bit less concerned with speed than I am disk space, and I was
>wondering if the following layout wouldn't be appropriate:
>
>index6( YYY, ZZZ );
>index7( XXX, YYY );
>index8( AAA );
>index9( BBB );
>index10( CCC );
>index11( DDD );
>
>I guess my question is: Can oracle approximate the performance of
>index1 by searching index8 and combining the results with a search of
>index7? Or will only index8 be used?
>
>Thanks for the advice,
>ry
>
>
Does your Oracle installation have a version and patchset?
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu Oct 02 2003 - 10:58:26 CDT