sql col_usage$



the AVG_ROW_LEN statistic for a table partition indicates the average size of a row in the table partition.

The BLEVEL statistic of an index partition indicates how many blocks have to be visited on the way from the index partition’s root block to a leaf block within the index partition.

The NUM_NULLS statistic for an object column defined at the partition level indicates the number of rows within the specified table partition where the object column is NULL.

查看OBJECT_ID

查询一些SELECT * FROM T_PEOPLE WHERE PERSONCODE='11111111';这里用到了PERSONCODE字段

查看COLUSAG$,注意这里没有INTCOL#为6的记录

调用 EXEC DBMS_STATS.GATHER_TABLE_STATS('SYS','T_PEOPLE');

再次查看col_usage$，已经包含personcode的记录