posted 24 years ago
Hi,
I need some clarification. Could someone explain what the Driving table is, and what its significance is? I'm trying to optimize my query....what are the things that I should keep in mind when optimizing ?
As far as I know,a Driving table is the table that is accessed first in a select statement. In the following statement:
SELECT * FROM EMPLOYEE E,ADDRESS A WHERE A.ADDNO = E.ADDNO
Is EMPLOYEE the Driving table, or ADDRESS, ie, the first table in WHERE clause or first table in FROM clause ? I'm confused!!!
Can someone point me to a good link where I can find answers to questions related to optimizing sql statements, and which conditions use indexes and which don't (using wildcards with LIKE clause disables indexes ???) and related doubts.
Thanks a lot. I appreciate all the responses.