create index 를 하면
517: The total size of the index is too large or too many parts in index.
라는 ERROR 가 발생합니다.
Informix Find Error 에서 517 을 찾아보면
The total size of the index is too large or too many parts in index.
All database servers have limits on the number of columns that can be included in an index and on the total number of bytes in a key (the sum of the widths of the columns).
This CREATE INDEX statement would exceed that limit for this database server.
Informix Dynamic Server and INFORMIX-Universal Server allow 16 key parts (columnar or functional) and a width of 390 bytes.
INFORMIX-SE supports 8 columns and a width of 126 bytes. Other Informix database servers allow 16 columns and 255 characters.
입니다.
Informix Dynamic Server 는 Index 를 390 byte 까지만 허락한다는 뜻인것 같은데
390 byte 를 더 크게 할 방법이 없나요?
고수님들 부탁합니다.
|