Change: Oracel Database 11g there are new several new OlapOLAP objects. The two that are queryable through the CUBE_TABLE function are CUBES and CUBE_DIMENSIONS. To ensure optimal explain plans   View changes from previous version. (Word count: 115)

Change: In 11 there are new several new Olap objects. The two that are queryable through the CUBE_TABLE function are CUBES and CUBE_DIMENSIONS. To ensure optimal explain plans the objects must be analyzed via the DBMS_AW_STATS package. Below is a sample script that analyzes all CUBES and CUBE_DIMENSIONS in a schema.   View changes from previous version. (Word count: 113)