Re: Informix vs. Oracle
Hi, The fetaure that I missed most in Informix is, oracle's way of optimizing the queries. In oracle, you have a choice of Rule based or Cost based optimizor. Also you can instruct the optimizer to behave in a particular way by using Hints.If you are concerned with whole throughput or just for best response time, you also have a way of configuring the oracle for that. The feature that I like of Informix is automatic fragmentation of tables and Indexes either on round robin fashion or based on expression. This basically free the DBA's from repetable time consuming job of extents looking, exporting and importing of a table as in ORACLE. I think that's the good idea of comparing these RDBMS head to head which will server the purpose of enlighting the user community aswell as the made think to those DBS vendors to incorporate the missing features. Thanks Rajesh Mittal >From ilist@rmy.emory.edu Fri Aug 8 11:04:30 1997 >Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id MAA13248 for informix-list-out; Fri, 8 Aug 1997 12:35:01 -0400 (EDT) >Message-Id: <c=NL%a=_%p=Simac_Techniek_N%l=ERP_NT1-970808140759Z-2325@mail.simac.nl> >From: Nils van der Laan <NilsL@simac.nl> >To: "'informix-list@rmy.emory.edu'" <informix-list@rmy.emory.edu> >Subject: Informix vs. Oracle >Date: Fri, 8 Aug 1997 16:07:59 +0200 >X-Mailer: Microsoft Exchange Server Internet Mail Connector Version 4.0.995.52 >Mime-Version: 1.0 >Content-Type: text/plain; charset="us-ascii" >Content-Transfer-Encoding: 7bit >Sender: informix-list-owner@rmy.emory.edu >Reply-To: Nils van der Laan <NilsL@simac.nl> >X-Informix-List-Id: <list.15872> > >Maybe this has been asked before in this list, but i'll give it a shot: > >Who could i better ask about the differences between Informix and >Oracle, than the Informix-users themselves. I would like to know which >features of Informix are superior, but also which features Informix is >missing compared to Oracle (maybe you know of some?) > >Thank you for you answers >> >>Nils van der Laan >>email: nilsl@simac.nl >> >> ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com