Index creation on compressed table

Hi All, Informix 12.10.FC2 on HP-UX B.11.31 If I have to create a index on a column of a compressed table (Informix Compression) then will it take more time as compared to creating an index on the same column of the same table when it is not compressed? Regards Vikas

Most often the answer is no, especially if you packed the table after it was compressed, because more rows fit on a page, so more CPU to decompress the rows to build the index keys, but less IO. Sometimes it's a bit slower, again especially if you did not pack the table. Depends on the data. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Aug 5, 2014 at 9:01 AM, VIKAS HIVARKAR <vikas.hivarkar@gmail.com> wrote: > Hi All, > > Informix 12.10.FC2 on HP-UX B.11.31 > > If I have to create a index on a column of a compressed table (Informix > Compression) then will it take more time as compared to creating an index > on > the same column of the same table when it is not compressed? > > Regards > Vikas > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11345d66f01eba04ffe23cb1