If you whant to stop searching after first finding, use the hint /*+first_rows */ in your SELECT query.
Forum Rules
Reply With Quote