RE: Index question
- From: J.Velikanovs@xxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 10 Aug 2004 23:39:55 +0300
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@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
>-----------------------------------------------------------------
----------------------------------------------------------------
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:
