Index tuning

[habesha]

I want to move a clustsred index from a primary key of a table to another key
how can I do this,
if I move it, does it affect other tables if hey have foreign key relation to this table

Thanks

 

[mrdenny]

You need to rebuild the primary key as a non-clustered index. You can then build your new clustered index on the new columns you wish to.

While this won't effect other tables directly it may impact the performance on querys which use joins on this table.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com