Re: What does sysindexes.clust contain?

graeme@pyra.co.uk (Graeme Sargent) writes: : Who can tell me what the numbers in the sysindexes.clust column mean? : : I realise that low numbers mean clustered and high numbers mean : unclustered, but what does (eg) 4000 mean? 4000 whats? Is 4000 : acceptably low or unacceptably high? : : If one wishes to write a utility which trolls through sysindexes looking : for tables which could do with reclustering this weekend, what should : one look for? : I'd be interested to know the answer to this also. I've just persuaded one of my customers to recluster indexes that were already marked as clustered and, sure enough, he is now happy with the query speed again. It would be nice to write a routine that would re-cluster automatically for him rather than having to advise him to run it when he starts to notice a fall-off next time. Regards Neil -- Neil S. Briscoe Telephone: +44 252 376737 System Administrator Fax: +44 252 376644 Email: neil@salmon.demon.co.uk nbriscoe@cix.compulink.co.uk