Table Statistics - Oracle PL SQL Course - Lesson 31 | SQL courses

Duration: 16:29 min

Summary: Every SQL statement that uses data stored in Oracle tables uses the information about statistics. However, most DBA and developers forget to create or update the statistics for tables, indexes and columns. This video explain how are statistics and histograms and how why they are important. The examples show how to gather the statistics using the ANALYZE command and check the blocks size allocation in the DBA_TABLES and the DBA_INDEXES views. The video also briefly talk about histograms and how to generate them in order to help the query optimizer choose a google execution plan based on the data distribution stored in columns of the tables.