query-optimizing possibilities

I wanted to ask if somebody can give me some hints, how I can optimize my SQL-queries.

For example which statements does the Oracle Optimizer prefer and not prefer (having vs. subselect, ANY, BETWEEN, OR,...)...so which statements should I use to perform a faster query!?

And my second question related to this topic: Would anybody be so pleased to explain me the following terms, and how they are involved in optimizing queries:

• execution area
• execution plane
• shared pool area
• optimizer

Maybe someone can give me some links where I can find more detailed informatin therefore.

thx Received on Mon Feb 04 2002 - 13:35:09 CST