robert.nesta123 (1/9/2013)
let me just get this straight theni think ive got what i need to do.
Column A PK
If my query needs this column then create an additional non clustered column A index . Then add more covering indexes on the non-clustered index to satisfy more queries when possible.
This will prevent sql using the large clustered pk, it will then use non clustered pk and satisfy multiple queries if possible.
It depends on the queries. Don't automatically make that change. You have to evaluated whether it is the right decision or not.