1.You need to see an execution plan of the query. (In order to understand how SQL Server process the query)
2.You can SET STATISTICS TIME,IO ON to see what tables are heavily accessed and more.
3. If it is pretty complex query, is there any possibilities to re-write it?
And much more......
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence
No comments:
Post a Comment