oracle实用技巧

查看表存在哪些索引

select * from user_ind_columns where table_name=upper('crm_ad_income_detail_tab');

添加索引

CREATE INDEX index_cai_record_id ON crm_ad_income_detail_tab  (record_id)

查看表占用空间

SELECT segment_name AS TABLENAME,
       BYTES B,
       BYTES / 1024 KB,
       BYTES / 1024 / 1024 MB
  FROM user_segments
  order by mb desc