如何在亿级记录表中创建索引牛

电无动力从“中间商”变身“服务商” 1. 查看表的具体情况 查看是不是分区表，有多少个分区、分区字段： SQL col table_name for a20 SQL col column_name for a20 SQL select ble_name,rtitioned,rtition_count,lumn_name 2 from user_tables a, user_part_tables b, user_part_key_columns c 3 where ble_name=\"STAT_SUBMIT_CENTER\" 4 and ble_name=\"STAT_SUBMIT_CENTER\" 5 and =\"STAT_SUBMIT_CENTER\"; TABLE_NAME PAR PARTITION_COUNT COLUMN_NAME -------------------- --- --------------- -------------------- STAT_SUBMIT_CENTER YES 50 MSGDATE 查看已使用的每个分区的大小： SQL select segment_name,partition_name,round(bytes/1024/1024) from user_segments where segment_name =\"STAT_SUBMIT_CENTER\" and bytes/1024/10240.25 order by 3 desc; SEGMENT_NAME PARTITION_NAME SEGMENT_NAME PARTITION_NAME ROUND(BYTES/1024/1024) -------------------------- ------------------------------ ---------------------- STAT_SUBMIT_CENTER STAT_SUBMIT_CENTER_ 1722 STAT_SUBMIT_CENTER STAT_SUBMIT_CENTER_ 1488 STAT_SUBMIT_CENTER STAT_SUBMIT_CENTER_ 1440 STAT_SUBMIT_CENTER STAT_SUBMIT_CENTER_ 1355 STAT_SUBMIT_CENTER STAT_SUBMIT_CENTER_ 1335 STAT_SUBMIT_CENTER STAT_SUBMIT_CENTER_ 1309 STAT_SUBMIT_CENTER STAT_SUBMIT_CENTER_ 1253 STAT_SUBMIT_CENTER STAT_SUBMIT_CENTER_ 1247 STAT_SUBMIT_CENTER STAT_SUBMIT_CENTER_ 1198 STAT_SUBMIT_CENTER STAT_SUBMIT_CENTER_ 1151 STAT_SUBMIT_CENTER STAT_SUBMIT_CENTER_ 1068 STAT_SUBMIT_CENTER STAT_SUBMIT_CENTER_ 1018 STAT_SUBMIT_CENTER STAT_SUBMIT_CENTER_ 865 STAT_SUBMIT_CENTER STAT_SUBMIT_CENTER_ 796 14 rows selected.