| ChrisR 2005-10-31, 1:23 pm |
| Yes, you would need to drop/ recreate. Profiler would be the easiest way to
look at the speed improvements.
On a side note, there may be times when you don't want clustering on the PK.
(Usually on a reporting server.) For example, you may want to have the
clustering on a date field as most reports are off of date ranges.
--
TIA,
ChrisR
"Joe K." wrote:
>
> I have application that I'm trying to enhance database performance.
> One of the ways to enhance database performance is make sure that your
> cluster indexes and non-cluster indexes are using the correct fields.
>
> This cluster indexes were not set on the primary key for several tables.
>
> What is the best way to test dropping Non-Cluster index (Primary Key) and
> dropping Cluster (Non Primary Key)
>
> Creating the Primary Key Cluster index and Non-Primary Key to Non-Cluster
> index.
>
> What is the easiest way to test the performance increase by dropping and
> create indexes that were set up on the incorrect fields?
>
> Thank You,
>
>
>
>
>
>
|