Re: db file sequential read, where does it read to?

"Mladen Gogala" <mgogala.spam-me-not_at_verizon.net> wrote in message news:pan.2006.11.03.03.41.28.793996_at_verizon.net...
> On Thu, 02 Nov 2006 09:39:36 +0000, Jonathan Lewis wrote:
>
>>
>> I've stuck a couple of comments about it on my blog at:
>> http://jonathanlewis.wordpress.com/2006/11/02/but-its-in-the-manual/
>
> Jonathan, in the referenced page, I found the following passage:
>
> "Efficiency
>
> A couple of standard guidelines for writing SQL - eliminate early,
> aggregate before extending. So let's apply them here."
>
>
> I am very interested in some kind of formal guiding principles for
> writing
> SQL. Do you have any books, articles or web pages you could recommend?
>
> --
> http://www.mladen-gogala.com
>

The only work that I happen to know of is the Dan Tow book on SQL Tuning. The Guy Harrison book is the classic of course, but more aimed at the details of specific Oracle operators.

I don't agree with some of Dan Tow's "philosophical" points, and there is a strong bias towards OLTP rather than heavy duty DSS, but it does have a sound generic strategy for analysing the SQL.

Alternatively, I have a one-day course on writing optimal SQL which gets its first airing on 20th Nov in the London

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html