Re: Problems with SELECT *

From: Pablo Sanchez <pablo_at_dev.null>
Date: Fri, 14 Mar 2003 11:04:57 -0600
Message-ID: <Xns933E6690CA881pingottpingottbah_at_216.166.71.233>

"Gianluca Hotz" <ghotz_at_alphasys.it> wrote in news:b4skjr$237et0$1_at_ID- 184953.news.dfncis.de:

> Another thing is that some system, provided there's an index,
> may "cover" the query fetching densely populated index pages
> instead of fetching the data pages.

It's unwise for application solutions to rely on 'piggybacking' off of indexes. If you can get away with it, that's great but I wouldn't bank on it, it's too fragile of a solution.

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com

Received on Fri Mar 14 2003 - 18:04:57 CET

This message: [ Message body ]
Next message: Tibor Karaszi: "Re: SQL (was: Why using "Group By")"
Previous message: Pablo Sanchez: "Re: Problems with SELECT *"
Maybe in reply to: Curtis \: "Problems with SELECT *"
In reply to Gianluca Hotz: "Re: Problems with SELECT *"
Next in thread: Tibor Karaszi: "Re: SQL (was: Why using "Group By")"
Reply: Bob Badour: "Re: Problems with SELECT *"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message