MVSFORUMS.com

schintala · Posted: Wed Jun 01, 2005 10:46 am Post subject: Cluster Index

Hi,
Can we alter the index to make it as clustered index? If so what would be syntax. We created table with unique index on it. Due to performamce issues we need to have cluster index on it now. I can not drop and recreat it as it involves lot of data with RI.

kolusu · Posted: Wed Jun 01, 2005 11:13 am Post subject:

schintala,

As a DBA you must be aware of the fact that there is generally NO advantage to having a clustering index on a primary key with a unique index if equal predicates are used

Fyi.. you cannot alter an existing index to a clustering index.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu