Re: Getting the first matching record???

Add " ROWNUM < 2" in your criteria. It will return one row only.

Alan

> >
> > I have a large table (about 4 million rows) that I need to search
> > through. Although the query I'm using can result to multiple rows, I
> > only need the first matching row. This query will be executed probably
> > a hundred thousand times. So I really need to optimize it
> >
> > What is the most efficient way of getting the first matching record
> > PL/SQL? and Pro*C?
> >
> > Thanks in advance.
> >
> > Please send your response to zlm101_at_psu.edu
> >
> >
> >
Received on Wed Apr 16 1997 - 00:00:00 CDT