Informix indexes 
Author Message
 Informix indexes

Quote:
>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



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Informix indexes

2. informix index(primary and unique,version 3.3 and 7.2)

3. informix index

4. Informix index error

5. Informix indexes

6. Problem with Informix index

7. Problem with Informix index sizing documentation?

8. INDEX( index, index, ... )


 
Powered by phpBB® Forum Software