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

You could try replacing recno with rowid in your query. If you are not bothered about the order in which the data is comming out of your table

select * from dbstruct where rownum = 1;

Mark

tim.mcconechy_at_runtime.dk wrote in message <7blnb1$1ki$1_at_nnrp1.dejanews.com>...
>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!
>
>Please help...
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Mar 04 1999 - 04:49:49 CST