Re: SQL Tunning techniques

dguimaraes wrote:
> Hi everyone,
>
> I'm looking for information about SQL Tunning optimization techniques.
>
> Basically information about how to write a correct SQL statement
> (avoiding the use of sort functions, unnecessary sorts, explain plan,
> etc) and also definitions about some techniques such as inter-query
> parallelism and intra-query parallelism, broke a statement to be
> executed into different sites and so on...
>
> Can anybody point me to a link where I can find this documentation?
>
> Thank you very much.
>
> Best Regards.
>
> Diogo Santos

Well oracle has pretty comprehensive documentation over at http://tahiti.oracle.com but it's somewhat intimidating to start with depending on how strong your background is.

Tom Kyte has written several books that you can check out at amazon. Jonathan Lewis has several books also.

There's a somewhat dated book by Guy Harrison called Oracle SQL High Performance Tuning. That one might be a good place to start then start looking at the Tom Kyte books.

Tom also has an online web self service place at http://asktom.oracle.com Received on Tue Nov 07 2006 - 11:31:06 CST