Getting the first matching record???

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 09 1997 - 00:00:00 CDT