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

"Mladen Gogala" <mgogala.spam-me-not_at_verizon.net> a écrit dans le message de 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
|

Have a look at "The Art of SQL" by Stéphane Faroult. http://www.oreilly.com/catalog/artofsql/index.html http://www.amazon.com/Art-SQL-Stephane-Faroult/dp/0596008945/sr=8-2/qid=1162540432/ref=sr_1_2/102-2411167-9090532?ie=UTF8&s=books

Regards
Michel Cadot Received on Fri Nov 03 2006 - 02:00:48 CST