Re: Informix indexes

>I have to decide to mirror the indexes yes or no.  If I don't mirror >the indexes then I can use two disks for the indexes to increase the >performance. > >The thought behind is that if a disk with indexes chrashes then it >is simple to regenerate > >the indexes in another dbspace. > >I this approch valid or is it better to miror the index disk/dbspace >and so why. > > >Note that all other spaces are mirrored. > > >Regards, > While this can be done by using detached indexes, I personally don't think that it's worth the effort. Normally the number is pages required for indexes is much smaller then the amount of space required by the datapages. Madison Pruet