Re[2]: Is Informix Reliable?

What are some examples of the optimizer taking bad paths? Just curious because we upgraded to 7.23 and I want to know what to look out for. Craig Laford Mailto:craig.lanford@alltel.com }We have found the SE product to be unreliable!!!! Screwed up indexes, }inaccurate row counts.... However, the Online version (7.2x) has been very }reliable from a data integrity standpoint. }The optimizer is psychotic, however there are workarounds. }>Warren Zeigler wrote in message <6a8n1h$k76$1@news.xmission.com>... }>I am currently evaluating Informix -vs- Oracle, and would appreciate your }>input. }> }>I have read on a few threads that people have had to unload and re-install }>the database to fix corrupted system tables, indexes, etc.. How often does }>this happen? }> }>Also, how reliable is Informix in client/server code, as compared to }running }>code on the same machine as the server? Are hung sessions rare or frequent? }>I need sessions to be able to stay up between middleware servers and the }>Informix server for months at a time. }> }>Thanks