創(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)
請(qǐng)問如何解決，創(chuàng)建索引？
在informix創(chuàng)建索引的時(shí)候報(bào)'索引的總大小過大或索引中的部分太多'
12345678_0001
2019-02-21 05:19:06
