Re: Getting the first matching record???

From: Chrysalis <cellis_at_iol.ie>
Date: 1997/04/09
Message-ID: <334C0EEA.6A4C@iol.ie>#1/1

Michael Agbaglo wrote:
>
> SELECT COUNT(*), A, B
> FROM ...
> WHERE ...
> GROUP BY A, B
> HAVING COUNT(*) = 1
>
> Z. Martinez <zlm101_at_psu.edu> schrieb im Beitrag
> <334bd241.9605767_at_news.cac.psu.edu>...
> >
> > 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
> >
> >
> >

Nonsense!
This does not achieve the desired result! It guarantees that if there is more than one matching row (count(*) > 1) no row will be returned at all!

Chrysalis. Received on Wed Apr 09 1997 - 00:00:00 CDT