Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!usc!rpi!zaphod.mps.ohio-state.edu!sample.eng.ohio-state.edu!purdue!haven.umd.edu!udel!rochester!rit!cci632!gnh
From: gnh@cci632.cci.com (George Hillenbrand)
Newsgroups: comp.databases
Subject: Re: Oracle CURSORS useless ?
Summary: Which databases avoid prefetch of entire cursor set?
Message-ID: <1991Jun27.140927.23374@cci632.cci.com>
Date: 27 Jun 91 14:09:27 GMT
References: <1991Jun26.033043.22948@sunaus.oz> <25762@oolong.la.locus.com>
Sender: gnh@cci.com	(George Hillenbrand)
Reply-To: gnh@cci.com   (George Hillenbrand)
Organization: Computer Consoles Inc. an STC Company, Rochester, NY
Lines: 10

In article <25762@oolong.la.locus.com> jfr@locus.com (Jon Rosen) writes:
>  ...  If the SELECT is only ordered on an index
>  and you are not doing anything else that requires prefetching the
>  entire answer set (like aggregate selection (HAVING) or something),
>  most DBMSs will not actually fetch the entire answer set but will
>  in fact retrieve it row-by-row for you.  ...

Which among the major relational databases (Oracle, Informix, Ingress,
Sybase...) avoid the prefetch for a select of a set of records having a
particular indexed field value?