which query is faster

#1

Which of the below mentioned query will be faster ?
and will the result of both the queries is same ?

A. select * from authors INNER join pubs
on authors.pubid=pud.id
where pub.active=1

B. select * from authors INNER join pubs
on (authors.pubid=pud.id and pub.active=1)

#2

Have you tested?

I cannot imagine there will be much difference if any.

What does the execution plan say?

Allan

"Vikram" <aa@aa> wrote

Quote:

Which of the below mentioned query will be faster ?
and will the result of both the queries is same ?

A. select * from authors INNER join pubs
on authors.pubid=pud.id
where pub.active=1

B. select * from authors INNER join pubs
on (authors.pubid=pud.id and pub.active=1)

#3

Vikram,

I will result in the same execution plan, hence the same result.

Ilya

"Vikram" <aa@aa> wrote

Quote:

Which of the below mentioned query will be faster ?
and will the result of both the queries is same ?

A. select * from authors INNER join pubs
on authors.pubid=pud.id
where pub.active=1

B. select * from authors INNER join pubs
on (authors.pubid=pud.id and pub.active=1)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

which query is faster

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

which query is faster - 11-17-2005 , 01:13 AM

Re: which query is faster - 11-17-2005 , 01:57 AM

Re: which query is faster - 11-18-2005 , 07:34 AM