I have create a type in Oracle (11gR2):
CREATE OR REPLACE TYPE MYARRAY AS TABLE OF VARCHAR2(4000);
I used this type in a Oracle function (str2tab). comma-separated string to collection. The function works but takes too long to execute in complex query.
Is there any way to index this Type "MYARRAY" to make the function faster?