Re: Oracle vs Informix...

Posted in 1995

Topics: Performance & Tuning, SQL Development & Query Writing, Stored Procedures & SPL

Barry Roomberg — Mon, 10 Apr 1995 14:49:27 GMT — source: Informix-list mailing list archive (1991-1998)

In article <mswph.6.001852B1@SunBelt.Net>, mswph@SunBelt.Net says: > >help ! >If you have any experience on RDBMS, please feel free to send me an email ! > >Q: What do you think about Informix, Oracle 7 and Sybase ? > Having worked with Oracle since V5 (now on 7.1.4), and Informix (don't know revs since it was blissfully short) I came to rhe following conclusion. Oracle's like a 63 Splitback Vette. Great performance, incredible control, but a bit bumpy ride and takes a while to master. Informix is a Hyndai with power windows. You can dress it up, but it still is trash. When working with Informix, I just LOVE when the manual states many of the SQL standard call are not implemented. It's also real fun when you find out the outer join logic just is plain WRONG! I got Informix support/engineering to admit this when we stepped through the logic of what it was returning, and they promised a fast fix, but then found out a bunch of customers were relying on the current behaviour, so they ignored it. I hope I'm never forced to work with it again.