Ebeworld’s Weblog

Trying to create

DB query optimization questions

1. Some where statement can be done using join statement. For example.
SELECT A.NAME FROM A,B
WHERE A.NAME=B.NAME; 
 
SELECT A.NAME FROM A JOIN B
   ON A.NAME=B.NAME;
 
which one the faster?
2.
 

November 1, 2008 Posted by ebeworld | Database, Interview Questions | | No Comments Yet