Clustering and Indexing HELP!!!!
From: Shawn Raymond <shawn_raymond_at_DSC.UMICH.EDU>
Date: Mon, 21 Mar 1994 08:09:21
Message-ID: <shawn_raymond.20.00082826_at_DSC.UMICH.EDU>
Date: Mon, 21 Mar 1994 08:09:21
Message-ID: <shawn_raymond.20.00082826_at_DSC.UMICH.EDU>
We are having serious query performance problems. I have made changes to some of the indexes and had great improvement (122 min to 9 min for one query). But this is still poor.
I have 3 tables that fit the clustering criteria. I want to do a hash key cluster on these three tables? I have a primary key index and multiple non-unique indexes for joins and commonly searched fields.
Do I eliminate indexes that used the same key fields?
thanks,
Shawn Raymond, Univ of Mich(sweet sixteen) Received on Mon Mar 21 1994 - 08:09:21 CET