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.