Re: Oracle is KILLING INFORMIX...
Posted in 1996
Topics: Performance & Tuning
Nils.Myklebust@ccmail.telemax.no (Nils Myklebust) wrote: >:> 2. If you have a table with 100000 rows and you just want >:> to select the first 20 rows according to a specified condition >:Agreed - this is a real wish list item for any developer. C'mon Informix, >:at least tell us why we can't have this facility, or better yet, tell us when >:it's getting released.... :-) >Not very high on my list as it's so easy to do via a cursor if you are >in any programming language (99.9% of our cases). >But the real issue is to say Oracle is superior based on these tiny >specs in the universe (of databases) is a strange opinion indeed. >If the original poster of these items had looked just a little at the >current performance of Informix and the new things they are now doing >with the Universal Server the picture becomes so different, and the >comparison is in a quite different balpark than what has been >discussed here. I Agree. Informix is putting out some very impressive stuff these days. The Illustra stuff and some of their SQL extensions are a few notable examples. All I can add to the original post is that there is generally too much mindless religious fevour among the Oracle weenies. If all one can do to demonstrate a 'superior' product is rant on about indexes, I would seriously question the expertise held by the ranter... Jon