FUDforum: PHP discussions » SQL optimization join

Home » General » PHP discussions » SQL optimization join

Show: Today's Messages :: Polls :: Message Navigator

SQL optimization join [message #168451]

Wed, 01 May 2013 08:38

Jack Hard
Messages: 7
Registered: December 2012

Karma:

Junior Member

I must to have some SQL queries every day, it generally involves joins I'd like to know which is the most properly way to do a join for example in this tables

A("a",x,y)
B("b",'a',z,w)

where a and b are primary keys,
which is better?

SELECT *
FROM a,b
WHERE a.a=b.a AND a.x<constant

or

SELECT *
FROM (SELECT * FROM a WHERE x < constant) t, b
WHERE t.a=b.a

It means, is better make first the where clause and after make the join or I can do the join and after filter by where

Report message to a moderator

[Message index]

		SQL optimization join By: Jack Hard on Wed, 01 May 2013 08:38
		Re: SQL optimization join By: eclipsewebmaster on Wed, 15 May 2013 14:17

Previous Topic:	PHP object scope
Next Topic:	html entity double escaping

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 08 13:52:44 GMT 2024

Total time taken to generate the page: 0.04767 seconds