RE: Index question

From: <J.Velikanovs_at_alise.lv>
Date: Tue, 10 Aug 2004 23:39:55 +0300
Message-ID: <OFB3C7A57E.89C1F303-ONC2256EEC.00712AAF-C2256EEC.007186A0@alise.lv>

100% agree !!!
No many sites have load simulation possibilities in test environments, unfortunately.
Fewer sites have close enough load simulation staff to have true build in test env.
Unfortunately “buffer busy waits” very difficult to check unless you are in production ;)
J.

On 10.08.2004 23:31:36 oracle-l-bounce wrote:

>> 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_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Aug 10 2004 - 15:49:19 CDT