Just want to know which join is better for querying data faster.
I have 2 tables A ( 70 GB ) & B ( 7 MB )
A has 10 columns & B has 3 columns.Indexes exist on both tables's ids.
select p.* from table A p, B q where p.id=q.id
or
select p.* from table B q , A p where q.id=p.id
Thanks
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com
Aug 02
Shafi AHMED RE: Which is better
Aug 02, 2011; 12:18
Shafi AHMED
RE: Which is better
Aug 02
Prabhat Kumar Re: Which is better
Aug 02, 2011; 10:40
Prabhat Kumar
Re: Which is better
Aug 02
Shawn Green (MySQL Re: Which is better
Aug 02, 2011; 14:46
Shawn Green (MySQL
Re: Which is better
Aug 02
David Lerer RE: Which is better
Aug 02, 2011; 14:52
David Lerer
RE: Which is better
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!