Jan
05

Optimizing SQL by the combined use of SHOWPLAN and NOEXEC

MDBitz - Matthew Denton SQL 2010-01-05

The NOEXEC option of SQL is used to specify that the SQL statements are not to be executed. Utilizing this command with the SHOWPLAN option enables us to quickly see the query plans for a SQL statement without having the query actually execute. This gives us a quick output of the steps the DB Server uses to execute the queries and if table scans or indexes are used.

Proper Usage

SET SHOWPLAN ON
SET NOEXEC ON
go
 
SELECT ID, F_NAME, L_NAME 
FROM USERS u WHERE u.GENDER = "F"
go
, , ,
Address: http://resources.mdbitz.com/2010/01/optimizing-sql-by-the-combined-use-of-showplan-and-noexec/
Share |
«
»
Trackback

no comment untill now

Add your comment now