|
|
Posted by Erland Sommarskog on 10/02/41 11:49
shark (xavier.sharon@gmail.com) writes:
> thanks for your help .
> a few queries ............
> you have mentioned
> about
>>1) review your indexing strategy to prevent scans
> how do i do this?do u mean that i should reconsider the columns that i
> use in clustered index?
That and non-clustered indexes. Since you did not post tables or the
actual statements, it is of course impossible for us here to suggest
anything.
Also, when you review indexing, you cannot only to this with this
particular deadlock in mind, but you do of course need to consider
other queries.
> will using an index hint help in this case?
Impossible to tell from this distance, but generally you should avoid
index hints, and only use them as a last resort.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|