[dba-SQLServer] interesting trick

Absolutely no difference - same exact query execution plan. 

-Paul 
SQL Server MVP


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
Harkins
Sent: Sunday, February 10, 2008 7:53 PM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] interesting trick

So, you don't think SELECT 1 is faster than SELECT *?

Susan H.


> The QP simply looks for the presence of a row. There is no real tip in 
> this
> thread.

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


__________ NOD32 2862 (20080210) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com