fast select of first row on Oracle table...

From: <tim.mcconechy_at_runtime.dk>
Date: Thu, 04 Mar 1999 10:30:12 GMT
Message-ID: <7blnbl$1m0$1@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:30:12 CST

This message: [ Message body ]
Next message: Stephen Vear: "Re: How do we run one Oracle instance from two servers ?"
Previous message: Pierre-Andre Morin: "Re: inserting non-english strings into oracle table"
Next in thread: Neil Cudd: "Re: fast select of first row on Oracle table..."
Reply: Neil Cudd: "Re: fast select of first row on Oracle table..."
Reply: Matthias Gresz: "Re: fast select of first row on Oracle table..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US