Re: SQL Tunning techniques

Dan Tow's SQL Tuning book is good.
ISBN: 0-596-00573-3
http://safari.oreilly.com/0596005733

Also,
the library at hotsos.com.

SQL Intensive Class from hotsos is probably the best sql class I've ever attended.

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
Received on Tue Nov 07 2006 - 12:11:44 CST