--通过dbms_stats.set_table_stats手动设置临时表统计信息
EODA@PROD1> create global temporary table t ( x int, y varchar2(100) )
2 on commit preserve rows; --创建基于事务的临时表
Table created.
EODA@PROD1>
EODA@PROD1> select table_name, num_rows, blocks, avg_row_len --查看统计信息
2 from user_tables
3 where table_name = 'T';
TABLE_NAME NUM_ROWS BLOCKS AVG_ROW_LEN
------------------------------ ---------- ---------- -----------
T
EODA@PROD1>
EODA@PROD1> begin
2 dbms_stats.set_table_stats( ownname => USER, --手动设置
3 tabname => 'T',
4 numrows => 500,
5 numblks => 7,
6 avgrlen => 100 );
7 end;
8 /
PL/SQL procedure successfully completed.
EODA@PROD1>
EODA@PROD1> column table_name format a10
EODA@PROD1>
EODA@PROD1> select table_name, num_rows, blocks, avg_row_len
2 from user_tables
3 where table_name = 'T';
TABLE_NAME NUM_ROWS BLOCKS AVG_ROW_LEN
--
通过dbms_stats.set_table_stats手动设置临时表统计信息
最新推荐文章于 2024-07-25 08:45:00 发布