Re: fast select of first row on Oracle table...

tim.mcconechy_at_runtime.dk schrieb:
>
> How can I select the first row in a table...
> I thought of doing.
> select * from dbstruct where recno=(select min(recno) from dbstruct)
> but this invlove table scanning which shouln't be necessary...
>
> I just want the first row...Fast!
>

You ought to specify what you mean with first row:

• the row with the lowest (highest) value in a certain column
• the row physically stored as the first row in the first block of the segment
• the row which was stored at first regarding timing

Matthias
--
grema_at_t-online.de

Protect privacy, boycott Intel: http://www.bigbrotherinside.org Received on Thu Mar 04 1999 - 09:27:35 CST