Re: Detaching Indexes

Striping would be the best solution!!! But Madison Pruet wrote also same other important aspects, checking out if I/O is the real problem!!! If there is a read-cache lower than 98% check if da-RA is a greatz portion of the dskreads. If so you can try "update statistics (low)" for the whole database. Rainer Schaub > Steve, > > This will help *if* your degredation is caused by IO bottle-necks. Generally > speaking, striping the data portions will improve performance even better. > > However, before any change is made to improve performance, careful analysis > needs to be done to the existing configuration to ensure that you have > discovered the "real" bottleneck that you are encountering. Check your onstat > -p. What is the read cache rate? - hopefully above 98%. Do the sar -A and > iostat reports indicate there is an large imbalance in the IO distribution > patterns. Are you seeing "wio" times? > Are you seeing "po" numbers and/or swapping? > > Basically, before any change is made to improve performance on you system, make > sure that you've carefully (and objectivly) analyzed the existing environment. > Moving data arround takes a lot of (down) time and you really want to make > sure that you will be getting the desired results before you start. > > Madison Pruet