--查看表所在表空间
select * from user_segments where SEGMENT_NAME='****'
--查看索引统计信息
SELECT * FROM user_ind_statistics WHERE index_name = '****';
--查看表统计信息
SELECT * FROM user_tab_statistics where table_name='*****'
--
exec dbms_stats.gather_table_stats(ownname => 'scott',tabname => 'work_list',estimate_percent => 10,method_opt=> 'for all indexed columns') ;
--
exec dbms_stats.gather_index_stats(ownname => 'crm2',indname => 'IDX_ADM_PERMISSION_PID_MID',estimate_percent => '10',degree => '4') ;
select * from user_segments where SEGMENT_NAME='****'
--查看索引统计信息
SELECT * FROM user_ind_statistics WHERE index_name = '****';
--查看表统计信息
SELECT * FROM user_tab_statistics where table_name='*****'
--
exec dbms_stats.gather_table_stats(ownname => 'scott',tabname => 'work_list',estimate_percent => 10,method_opt=> 'for all indexed columns') ;
--
exec dbms_stats.gather_index_stats(ownname => 'crm2',indname => 'IDX_ADM_PERMISSION_PID_MID',estimate_percent => '10',degree => '4') ;