RE: Index question
- From: Jared.Still@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 10 Aug 2004 13:31:36 -0700
> Rick, have you considered using index compression?
> On the complex indexes this feature can give the significant improvement
> and can even compensate complex index overhead.
It would be a good idea to test this first in a production like
environment.
Index compression is a recipe for causing buffer busy waits on
heavily updated indexes.
Jared
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
