Lower Oracle High Level bit

Slow query speed due to a large number of delete operations causing the space to not be released and the horizontal bit high

--high level position due to a large number of delete operations causing the space to not be released
ALTER TABLE tb_trm_scoresumfinish move;

--After lowering the level, you need to do index reconstruction
Alter index INDEX_SCORE_001 rebuild;

--re-collect statistics for tables
exec dbms_stats.gather_table_stats (ownname = ' Lgehr ', tabname = ' tb_trm_scoresumfinish ', estimate_percent = > 100,method_opt=> ' for all indexed columns ', cascade=>true);

--View Table object space size
Select sum (bytes)/1024/1024
From User_segments
where segment_name = ' tb_trm_scoresumfinish ';

Lower Oracle High Level bit