|
Re: Sql query taking long time to execut [message #676212 is a reply to message #676210] |
Tue, 21 May 2019 02:57 |
cookiemonster
Messages: 13943 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
You'd find out what the query is spending it's time doing by looking at the explain plan / execution plan / tkprof of a session trace.
You'd then change the query / add indexes / make other changes.
If you want a more specific answer I suggest you post the query along with an execution plan.
|
|
|
|