Difference of execution between TOAD and SQLPLUS

Hi

I have an Oracle 19.13 on windows x64.

I've notice a difference of execution between Toad and SQL PLus with the same user and the same instance.

I have a query that when I execute on TOAD it executes in 9 secondes.

And when I executes on sqlplus , on the database server in CMD, it takes more than 1 minutes.

And I can see that the explain plan is lightly differente.

I suspect TOAD to modify slightly via hints or other as session parameter, the execution of the request, what do you think?

 My version of toad 16.1.53.1594



Regards

Parents Reply Children
No Data