I have a query that runs in 2 ms i sqlplus or SQLDeveloper, however in Toad never returns the result and after sometime it becomes unresponsive. Query takes long to run in toad than in SQLPLUS or SQLDeveloper To: Query takes long to run in toad than in SQLPLUS or SQLDeveloper How are you running the query? F5 (as a script) or F9? If using F5, it’s because it’s trying to return the entire dataset. RE: Query takes long to run in toad than in SQLPLUS or SQLDeveloper To: RE: Query takes long to run in toad than in SQLPLUS or SQLDeveloper Please consider the environment before printing this email.
0 Comments
Leave a Reply. |