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.
-
Recent
-
Links
-
Archives
- August 2009 (1)
- July 2009 (2)
- April 2009 (4)
- March 2009 (6)
- February 2009 (5)
- January 2009 (4)
- December 2008 (3)
- November 2008 (35)
- October 2008 (20)
-
Categories
-
RSS
Entries RSS
Comments RSS