Normally when there is an issue on the performance one really want to see how many indexes are defined on a table.
the simpest command to get this information is sp_helpindex
where just pass the tablename as the input parameter to the procedure then it will list out all the indexes defined on that table.
No comments:
Post a Comment