Re: Cluster index or not ?

Quoting Poul Pedersen... > > Do any of you know when I may use a cluster index ? > You can use a cluster index any time you want. > How often may I recluster the index (alter...). > You can re-cluster as often as you want. > Deletes will be very uncommen. > A lot of updates. > A lot of queryes. > Cluster indexes are best on static tables. I have a clustered index in my zipcode table (cause we very rarely change that table). Clustering will improve your queries and deletes shouldn't affect the clustering (unless they are followed by adds). Updates may affect the clustering but only if the columns that makeup the clustered index are changed. DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.4 UUCP: ..!uunet!das13!dave INTERNET: Dave.Snyder@snide.com