25112
asked on
clustered and nc index on same columns- is that harmless
it makes no sense, but the prev designer has a clus index and also nc index on the same set of columns on a table. but is this harmless or can it cause problems..
the reason i ask is that the index was corrupted in this table.. could it have been because of the above fact?
(there are duplicates that should have never gotten in )
the reason i ask is that the index was corrupted in this table.. could it have been because of the above fact?
(there are duplicates that should have never gotten in )
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.