天天看點

ksql建立索引

例如:其中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);