Other Tuning Tricks
Whenever you try to optimize a query, you should be on the lookout for obstructions that can lead to poor performance. The following sections discuss common causes of poor query performance.
Are You Trying to Tune an UPDATE, DELETE, or INSERT Query?
If you are trying to tune an UPDATE, DELETE, or INSERT query, does the table have a trigger? The query might be okay, but the trigger might need improvement. An easy way to determine whether the trigger is the bottleneck is to drop the trigger and rerun the query. If query performance improves, you should tune the trigger.
Does the Query Reference a View?
If the query references a view, you should test the view to determine whether it is optimized. An easy way to test whether the ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
