Need a help strategy in creating indexes..
I have a Query which returns me more then 4 billion rows, which i am trying to insert into a table. There are views and table in the query.
I am working on SQL Server 2000.
So i thought if we create indexes on primary key columns on the table(which are used in views), on the columns used where condition of the main query.
Will creating clustered index on the table which more than one primary key helpful?
Is my strategy correct? any suggestions will be of great help!
View Complete Post