Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 604
  • Last Modified:

Explain query

What can by used to explain a query for performance?
0
dougbohl
Asked:
dougbohl
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
query analyser -> View Execution Plan.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
the execution plan is the best method
0
 
fauxDBACommented:
Yes indeed its the Execution Plan . Have a look at this tutorial, it would help you as to how to generate one & show you what all to look for.

http://www.codeproject.com/cs/database/sql-tuning-tutorial-1.asp


Regards
Bharat Butani.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now