Operating System - OpenVMS
1748216 Members
3571 Online
108759 Solutions
New Discussion юеВ

Re: Oracle RDB delayed SQL request

 
SOLVED
Go to solution
Richard J Maher
Trusted Contributor

Re: Oracle RDB delayed SQL request

Hi Dmitry,

Just checking on this post and see you gave me 10 points. Can I take it that the ORDER BY convinced the optimizer to use the correct (optimum :-) index/strategy ?

Performance any better over all ?

Cheers Richard Maher

Re: Oracle RDB delayed SQL request

Hi Richard,

Yes, you are correct, adding ORDER BY at the end of the statement eliminates this delay (ordering by all three columns).

Also thanks to Jean-Francois, MAX_STABILITY flag resolves the issue as well.

Two solutions, in fact... But working further with the customer we figured out that current database was corrupter for some reason. New instance of DB was provided and it didn't contain any issues like this.

Anyway, thanks to everyone for input and discussion, I appreciate this.
Closing the thread since issue is resolved.

Re: Oracle RDB delayed SQL request

See comment above.