About Tuning the SQL clause!

I don't think I konw how to tuning the SQL clause,and the following is a example ,and in the future ,I will add more!

[@more@]

--Before we see the example,I will first declare sth about the
--table A and B;
--A.column1 don't have a index
--B.column2 is the primark key of table B
--1
SELECT *
FROM A,B
WHERE A.column1=B.column2
--2
SELECT *
FROM A,B
WHERE B.column2=A.column1
--3
SELECT *
FROM A,B
WHERE SUBSTR(B.column2,1,2)=A.column1
--Frankly speaking ,I am nou quite sure about the method to
--see the time for executing the SQL clause;But I know the answer
--The answer is the second,for B.COLUMN2 is a primary key ,and it has a
--index,so it should be put to the left of "=";
--For the third one ,If we use a function on a index column , and it will not
--be used for tuniong.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10484922/viewspace-975985/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10484922/viewspace-975985/