Click here to Skip to main content
14,425,522 members
Rate this:
Please Sign up or sign in to vote.
Hi,
Is there any sql query analyzer tool from where I can check which way is better.


Regards
Seema
Posted
Rate this:
Please Sign up or sign in to vote.

Solution 2

You can do a lot from within management studio, the third link posted by JF2015 is essential reading

If you've got the Northwind database, open a new query window against it and put in the following SQL

SELECT CustomerID, CompanyName
FROM dbo.Customers
WHERE City= 'London'


Now choose Query -> Display Estimated Execution Plan

The database engine will show you that for this query it will attempt to perform an Index Seek against the index named City

Now try the same thing with this SQL

SELECT * FROM  Orders O
WHERE ShipCity Like  '%London%'
ORDER BY OrderDate


You'll notice this time it's performing an Index Scan (80% of total query Cost) and a Sort (20%).

Depending on the amount of rows in the table, you would generally want to avoid a Scan. The engine has to analyse all the rows in the table to determine which rows qualify for your statement

http://blog.sqlauthority.com/2007/03/30/sql-server-index-seek-vs-index-scan-table-scan/[^]

The execution plan window is a really useful part of SQL Server, you should get used to checking SQL statements here.
   
Comments
Espen Harlinn 29-Jan-11 4:50am
   
5+ Nice additional info

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100