Re: query-optimizing possibilities

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Mon, 04 Feb 2002 20:18:48 GMT
Message-ID: <3C5EECA8.5E2B8E1B@ci.seattle.wa.us>

If there were hard and fast rules no one would be writing unoptimized SQL.

You need to learn EXPLAIN PLAN and use it.

Optimizing SQL is not just about the SQL. It is also about indexes and statistics and object_types, and many other things.

Daniel Morgan

TheLetti wrote:

> 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 - 14:18:48 CST