Optimizing queries:: The Rules

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. Received on Wed Feb 06 2002 - 13:57:33 CST