Re: Index on columns that have total of more than 255

Gaspy wrote: > > Greetings, > > We have this client software that was developed using Oracle and > we have this table that the total bytes of the primary key is more than > 255. Oracle allowed us to do the above subject. > When we export the database from Oracle to Informix, I am getting > an error "517: The total size of the index is too large or too many > parts in index." on this table. > > My question is why I cannot do the above subject on any of the > Informix database? > The maximum supported number of bytes per index is 255. If one of the columns is a varchar you must also count an extra byte for the byte count for that column. Art S. Kagel