Re: Optimizing Queries, Views vs Tables - Info Needed

Tons and tons and tons of it.

If you are looking for "rules of thumb" they differ from version to version of the optimizer and are usually wrong.

In Oracle you need to learn EXPLAIN PLAN and TKPROF.

To find these materials go to http://technet.oracle.com and search under tuning and optimizing.

Daniel Morgan

James Alexander Starritt wrote:

> Guys,
>
> I'm going to be starting creation of some training materials soon and would
> like to know if there are any resources on-line the explain how to optimizie
> queries - yunno standard stuff like what selections to run first. I would
> also like to know if there is any text out there explaining how and why and
> views are slow -- I know the answers but I tend to not dumb stuff down
> enough sometimes and would like a basic outline to start working from.
>
> Any ideas ?
>
> James
Received on Thu Feb 07 2002 - 14:32:06 CST