This content has been marked as final. Show 3 replies
Speed of sql is related to complexity of sql which in turn depends on logical IOs and waits.
Select 'fast sql' from dual;
would be faster than
Select (some_function_calling_10s_of_big_tables) from dual;
Analyze what the function is returning and why it is needed. Tune the function or better yet, include the logic in sql.
Olivejuice, good question, so I've jotted down a few comments at the following URL:
That was so quick and awesome. No wonder you are an Oracle Guru.
Thanks and Regards,