創(chuàng)建informix數(shù)據(jù)庫表索引的時(shí)候報(bào)——'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)
請問如何解決,創(chuàng)建索引?
走同樣的路,發(fā)現(xiàn)不同的人生