The return cursor(SYS_REFCURSOR) is too much slow
I have a table :"CUSTOMER" with two thousand of records, the required
time to retrieve this information with a query is less than 2
SELECT * FROM CUSTOMER
But i need get this information through a function that require more
than 2 MINUTES!!!
FUNCTION getCUSTOMER( ) RETURN SYS_REFCURSOR AS
OPEN cur FOR ' SELECT * FROM CUSTOMER ';
There is any database parameter that i need change ? Any suggestion,
Are you looking for a silver bullet like _do_it_faster=true?
Originally Posted by sandy_soft
What kind of application would require to do a "select *" with no predicate on the customers table? may be is time to look at database/app design before looking at backend side.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width