Rumah > Soal Jawab > teks badan
创建informix数据库表索引的时候报——'The total size of the index is too large or too many parts in index'
语句如下
CREATE INDEX
index_alt
ON yzym_e_alt(etpsid,uniscid,ALTDATE,ALTAF,ALTBE,ALTITEM,REGNO,s_ext_timestamp)
etpsid,uniscid,ALTDATE,ALTAF,ALTBE,ALTITEM,REGNO,s_ext_timestamp 是表yzym_e_alt中字段,其中ALTAF,和ALTBE字段是lvarchar(3000)
请问如何解决,创建索引?