INFORMIX SE AND INDEXING

Posted in 1994

harry@boi.hp.com — Tue, 29 Mar 1994 17:11:36 GMT — source: Informix-list mailing list archive (1991-1998)

With Informix SE, over the course of the last few months, we have been experiencing substantial performance degradation. One thing that has been done is adding more indexes to tables. What are the effects of adding indexes? How does this change the performance? Is the order of index generation important? It is the reporting aspect that has been hit the hardest. Unfortunately, all of the indexes are used to aid in reporting and all of the indexes are used. Online is not an option. Any help would be appreciated. Harry Lynch harry@hpdmm43.boi.hp.com