Oracle SQL Optimization & Implementation [message #209539] |
Fri, 15 December 2006 07:32 |
annagel
Messages: 220 Registered: April 2006
|
Senior Member |
|
|
Not exactly a SQL question, but seemed like the right place to ask still.
I was wondering if anyone has any recommendations for book on advanced SQL, I am looking for something that can teach me stuff beyond how to write queries. Stuff like how the optimizer works, how to use the explain plans effectively, what the pieces of the explain plan mean, how Oracle actually goes about executing the query once the plan is made, how indexes actually work all kinds of fun stuff like that....so any recommendations?
Thanks, Andrew
|
|
|
|
Re: Oracle SQL Optimization & Implementation [message #209571 is a reply to message #209564] |
Fri, 15 December 2006 10:29 |
annagel
Messages: 220 Registered: April 2006
|
Senior Member |
|
|
Frank wrote on Fri, 15 December 2006 10:06 |
Note that these books are quite tough!
|
Well I was not expecting rainbows and roses, so tough is what I expected, and what I was looking for. Thanks for the info, hope I find these helpful, the reviews of the O'Reilly are quite good so I am hopeful.
Andrew
|
|
|