Detaching Indexes

To spread the workload on our drives, we have taken the approach of detaching the index from our tables. Our indexes are on one set of disks and the data is stored on another set of disks (ie, physically separate disks). If some cases we have seen comparable results when the indexes are attached vs. indexes not attached. Lately, we have seen our performance begin degrade. The only things to change in our environment is the amount of data has increased and initializing the instance in using Shared Mem as opposed to TLITCP. Any thoughts on the +'s or -'s of distributing data in this way? PS. We are running on Solaris 2.5.1 and ODS 7.23UC1. -- ----------------------------------------------------------------- Steve Romankiw + Executive Risk Inc. + DBA + email: sromankiw@execrisk.com 82 Hopmeadow Street + work: (860) 408-2474 Simsbury,CT 06070 + fax: (860) 408-2139 -----------------------------------------------------------------