Re: Newbie-Limiting rows returned in query

How does oracle impliment this query? Does oracle complete the entire query, then return the first 10 rows, or does it stop scanning the table/index/whatever after the 10s row? Does ALL_ROWS, FIRST_ROWS effect this at all? I would guess know becuase that is just used by the optimizer, but then again, stopping after 10 rows in a optimize type thinggy.

• Paul

peter wrote:

> Yes , try use rownum keyword.
>
> select * from table where rownum < 10;
>
> John Shaft wrote in message ...
> >Does Oracke offer some way to liit the rows returned in a query? For
> >instance say I want so select all the rows in a table sorted by name, but
> >I only want the first ten names. Can I limit to rows 1-10?
> >
> >Thanks!
> >
> >shaft_at_meanmutha.com
> >http://www.meanmutha.com
> >
Received on Sat Dec 18 1999 - 01:22:42 CST