Execution time diff between two select queries in sql server 2005

Question

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

Chris W · Accepted Answer · 2011-07-18 16:27:13Z

1

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.

answered Jul 18, 2011 at 16:27

Chris W

3,3143 gold badges28 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Aaron Bertrand Over a year ago

Agreed. In addition, the better practice is to use the first form. For one, it allows you to separate join criteria from filter criteria, which makes the query easier to read for most people. It also makes it harder to accidentally get a cartesian product by leaving out the join criteria or specifying it incorrectly. It's still possible, but it's harder.

NMK · Accepted Answer · 2011-08-16 10:48:40Z

0

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

answered Aug 16, 2011 at 10:48

NMK

511 silver badge4 bronze badges

Collectives™ on Stack Overflow

Execution time diff between two select queries in sql server 2005

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related