Re: Does Oracle allow configuring - number of records returned?

From: Patel <sajidpatel_at_rediffmail.com>
Date: Fri, 14 May 2004 22:47:10 GMT
Message-ID: <Hxq7AL.6LK@news.boeing.com>

Consider this case:

I have an application with oracle database in backend. The Frontend allows users to query data based on some criteria. The data retrieved is displayed on the screen. The application limits the number of records queried to 5000.There could be millions of records in the database.

I was trying to understand, from performance aspect - oracle will always return millions of records, but only 5000 are required. Is there any way to limit ?

Ofcourse where clause would be used to filter the results, still the result could be huge number of records.

"Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message news:c83bfk$67k$2_at_news1.tilbu1.nb.home.nl...
> Patel wrote:
>
> > Does Oracle allow configuring - number of records returned by a query?
> > Is there a default limit?
>
> No. Yes: all
> Who would like to see maybe-but-not-all data?
> --
>
> Regards,
> Frank van Bortel
>
Received on Fri May 14 2004 - 17:47:10 CDT