Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Initializing and Populating the Siebel Customer-Centric Enterprise Warehouse >

About the Table Analyze Utility

Most databases have a feature to analyze and gather statistics for a table. By analyzing a table, one can store the key distribution, index distribution, average row size, and a lot more other useful information related to the content of the table.

The Siebel Customer-Centric Enterprise Warehouse uses the Table Analyze Utility to analyze tables after they are loaded. After the data is loaded into a table, the Table Analyze Utility uses an analyze table command for the specific table in the correct database. If the next session uses the previously analyzed table as a source and pushes SQL to the database using this table as a joined table, then the database knows that statistics are available for the table and it can produce the most effective execution plan immediately. The Table Analyze Utility improves the overall ETL performance.