We tried to create a virtual table and mapped that table with our actual table and changes the materialized option in the table properties to true. We then deployed the vdb after specifying the data sources etc.We didn't find any signifact change in the performance. Do we have any other way of doing this? I tried to add "/*+ cache */" OR /*+ "cache(pref_mem ttl:60000 */". But, when we tried to add it prior to CREATE VIRTUAL PROCEDURE and tried to save/validate, it vanishes i.e. the changes got removed automatically. We treid several times but all in vain. Can you tell us its solution?? And also if there is any other better way implementing caching?

Any Help will be appreciated?