Re: Optimizing queries:: The Rules

Sandy Murdock wrote:
>
> I am (by far) more familiar with SQL server than Oracle.
>
> I am aware of a great many 'Rules of Thumb' for making your
> queries/stored procedures run faster. How to determine which table to
> join to which when the join can be made from more than one table in
> the query, order of operation, naming issues etc.
>
> I have not had much luck in finding the same for Oracle.
>
> 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???
>
> 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.
>
> Thanks.

Two books to read (that are free):

1. Oracle Concepts
2. Oracle Performance Guide

both on otn.oracle.com (follow the documentation links).

Read them back-to-back, and you'll know more about Oracle than most.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."