Re: Index clustering and performance

Land, Todd wrote: > Isn't there something I can do to my indices (re-cluster?) to regain > performance? > > The OnLine Administrator's Guide (admitedly an older copy) doesn't say > anything about perfomance except for initial tuning parameters. Help! > (We're using OnLine 7.x) Under 'some' circumstances, dropping all but one index (preferably the one on a primary [unique] key), altering that index to cluster, then rebuilding the dropped indexes (indices?) , you can defragment a table. It depends on the dbspace/chunk usage and availability as to how successful this is. I've tried it and didn't get very good results. Someone else probably has better suggestions. -- Sincerly, Doug Wilson(dougw@amgen.com) *** The opinions expressed here are my own and not neccessarily *** *** anyone elses **** *** Disclaimer: These are the opinions of the poster not Amgen Inc.***