Re: Optimizing queries:: The Rules

"Sandy Murdock" <jmurdock_at_dialoguewizard.com> wrote in message news:ac4a5663.0202061157.2927054e_at_posting.google.com...
> There is a lot about using performance optimizing tools to help, but
> wouldn't it be easier for me if I just wrote better code in the first
> place - THEN optimized that???

Thank you. You can't believe how rare this attitude actually is.

> The applications that we are building use Packages and Stored
> Procedures only, no query is allowed to run that we do not build in
> advance.
>
> Anyone know a good source of such information. I am not looking for
> just syntax for SQL, but information on when to use which command for
> efficiency reasons etc.
>
> If you know of a good source please let me know. Internet is better
> (it is immediately available and searchable) but I am not at all
> adverse to getting in my car and buying a book.

Connor has recomnmended the Concepts and performance guide for oracle and I'd second that. I'd offer two book recommendations for you as well.

Oracle PL/SQL Programming by Steven Feuerstein et al. & Expert one-on-one Oracle by Tom Kyte.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************