Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Problems with SELECT *

Re: Problems with SELECT *

From: Bob Badour <bbadour_at_golden.net>
Date: Fri, 14 Mar 2003 13:25:08 -0500
Message-ID: <7Cpca.44$lE4.5312631@mantis.golden.net>


"Pablo Sanchez" <pablo_at_dev.null> wrote in message news: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.

He never recommended that applications rely on this. He suggested that writing applications to explicitly request the data they need will sometimes allow this optimization. Using "SELECT *" indiscriminately will generally prohibit it. Received on Fri Mar 14 2003 - 12:25:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US