CREATE INDEX GXQUSR.IDX_AGGERATION_PUSH_RECORD_SERIAL_NO ON
GXQUSR.FUND_AGGERATION_PUSH_RECORD
( SERIAL_NO )
COLLECT SAMPLED DETAILED STATISTICS COMPRESS NO ALLOW REVERSE SCANS;
sql 解析:
GXQUSR 是Schemas 命名空间
IDX_AGGERATION_PUSH_RECORD_SERIAL_NO 索引名称
FUND_AGGERATION_PUSH_RECORD 表名
SERIAL_NO 需要加索引的字段,多个用逗号隔开
COLLECT SAMPLED DETAILED STATISTICS COMPRESS NO ALLOW REVERSE SCANS 固定写法,作用待查