Oracle 给表关键字段批量添加索引生成脚本语句

Oracle 给表关键字段批量添加索引生成脚本语句：
-- 查看所有索引：
SELECT * FROM dba_indexes where OWNER = 'MCS';
-- 查看owner = MS
SELECT * FROM dba_indexes  WHERE owner = 'MS' AND index_type='NORMAL';
-- 查看索引大小
SELECT
    si.index_name,
    si.table_name,
    si.leaf_blocks * avg_row_len / 1024 / 1024 AS "Size_MB"
FROM
    dba_indexes si,
    (SELECT
         table_name,
         owner,
         AVG_ROW_LEN,
         num_rows
     FROM
         dba_tables
     WHERE
         owner = 'MCS') st
WHERE
    si.table_name = st.table_name
    AND si.owner = st.owner
    AND si.owner = 'MCS';
    
-- 查看用户表、索引、分区表占用空间
select owner,segment_type,segment_name, sum(bytes)/1024/1024 siez_Mb from dba_segments group by owner,segment_type,segment_name order by 4 desc;
    
-- 3.表占用空间
select segment_name, sum(bytes)/1024/1024 Mbytese from dba_segments where segment_type='TABLE' group by segment_name;