The IG is taking a long time around 45 seconds to load. The SQL query behind the IG when run as a SQL in Database takes 6-12 seconds. I have enabled the debug and see that the COLLECTION truncate is taking a long time. Please help if this can be reduced.
The IG is of type Function returning SQL and using the below condition in the
IF NOT APEX_COLLECTION.COLLECTION_EXISTS('FF_BILLING_DETAILS_COLLECTION') THEN
APEX_COLLECTION.CREATE_COLLECTION('FF_BILLING_DETAILS_COLLECTION');
else
APEX_COLLECTION.truncate_collection('FF_BILLING_DETAILS_COLLECTION');
END IF;