Which of the following design strategy can reduce the occurrence of blocking locks ?
A. Use non-clustered indexes on high-usage tables
B. Use clustered indexes on high-usage tables
C. Use clustered indexes on less-usage tables
D. Make sure that CREATE and DROP statements use an existing index
Answer:A
Which of the following design strategy can reduce the occurrence of blocking locks ?
A. Use non-clustered indexes on high-usage tables B. Use clustered indexes on high-usage tables C. Use clustered indexes on less-usage tables D. Make sure that CREATE and DROP statements use an existing index
Explanation:Clustered index should be created on frequently used tables. 2. Point out the correct statement :