What is faster?

[SFiend]

SELECT I.*
FROM Form F, Inp I
WHERE F.Id LIKE $Id AND F.Id LIKE I.IdForm

or

SELECT I.*
FROM Inp I, Form F
WHERE I.IdForm LIKE $Id AND I.IdForm LIKE F.Id

what do you think?

 

[r937]

depends on whether there are indexes defined on those columns

is this a trick question?

F.Id LIKE I.IdForm is not the right way to join tables

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[SFiend]

NO? I use it all the time I want to join tables. Is any faster solution?

 

[r937]

you could try F.Id = I.IdForm

i'm not saying it will necessarily be faster, but it sure is easier to understand



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[ericbrunson]

I think the optimizer should understand that it's should use equality.