CODEWITHSUNDEEP
sql-server-2005
Selva
Selva

Reputation: 839

Execution time diff between two select queries in sql server 2005

Please tell the execution time difference in sql server 2005

select table1.* from table1 inner join  table2 on table1.id=table2.id

And 

select t1.* from table t1, table t2 Where t1.id=t2.id

Upvotes: 0

Views: 456

Answers (2)

NMK
NMK

Reputation: 51

If u rusing sql server 2005 use

SET STATISTICS TIME ON

SELECT * FROM view_Consignment_Packet_Job

SET STATISTICS TIME OFF

SET STATISTICS TIME ON if use this ,u can c in message tab execution time

Upvotes: 0

Chris W
Chris W

Reputation: 3324

I'd expect the SQL Server query optimiser to evaluate these in exactly the same way so you should see no difference at all in execution.

You can confirm of course by checking out the execution plans that can be generated within Management Studio.

Upvotes: 1

Related Questions