Re: Getting the first matching record???

Z. Martinez wrote:
>
> 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

SELECT  ......
FROM    ......
WHERE   ......
AND     ROWNUM = 1;

... but be careful. ROWNUM is evaluated before any ORDER BY is done.

Alternately, in PL/SQL, set the query up as a CURSOR. Open the CURSOR and FETCH only 1 row.

-- 
=================================================
Jerry Apfelbaum           email: japfelba_at_ican.ca
Eastern Sun Group Inc.    phone:     416.769.8738 
Toronto, Canada             fax:     416.769.7428