This content has been marked as final. Show 2 replies
Hi, The speed depends on which view you are querying and the the number of tables the view refers.
You could try querying the underlying tables directly by checking the view definition.
One thing that you need to do to ensure good query performance in OC is to make sure the database has statistics created for the OC tables via the "analyze table" command. The cost-based query optimizer in Oracle relies on up-to-date table statistics to optimize queries. Table analysis should be performed regularly by the DBA. OC provides scripts to run the table analysis. They are in the $RXC_INSTALL directory and are named anarxctab.sql, anadestab.sql, and analrtab.sql.