Re: Performance problem with SQL query

Hi Mark:

Yes, all the code examples are 8i-compatible. I would definitely try the ROWNUM approach first (coupled with the first_rows hint).

-Todd

On Tue, 9 Sep 2003 11:08:19 GMT, Mark.Wright_at_bristol.ac.uk wrote:

>Hi Todd, thanks for all your replies! I am on holiday for this week, but
>will definitely try all your ideas next week.
>Are these new methods you describe all available in Oracle8i?
>Also, there is little chance of me being able to alter
>optimizer_index_cost_adj. I would be worried about breaking queries
>elsewhere even if we had permission to get that done!
>Cheers,
>Mark
Received on Tue Sep 09 2003 - 14:35:27 CDT