例如:其中IX_HP_CT_CT是索引名,T_HPB_ClockingTime是表名,FClockTime是列名
if not exists(select * from KSQL_INDEXES WHERE KSQL_INDNAME='IX_HP_CT_CT')
create index IX_HP_CT_CT on T_HPB_ClockingTime(FClockTime);例如:其中IX_HP_CT_CT是索引名,T_HPB_ClockingTime是表名,FClockTime是列名
if not exists(select * from KSQL_INDEXES WHERE KSQL_INDNAME='IX_HP_CT_CT')
create index IX_HP_CT_CT on T_HPB_ClockingTime(FClockTime);