Re: Advice on picking a database (Oracle, Sybase, Informix, SQL Server

In article <3310ABC6.6338@interpath.com>, Ken Denny <kdenny@interpath.com> writes >Matt Larson wrote: >On a recent project we were evaluating Oracle vs Informix. Although >Informix had a lot of good things going for it, what made us settle on >Oracle was that there was one place in the application where we had a >table which used two columns (SITE and NAME) as its primaty key. We >needed to start with a particular site and name and select all rows from >there to the end of the table. The where clause in our select statement >was: >WHERE SITE > START_SITE OR (SITE = START_SITE AND NAME >= START_NAME) >Because there was an "OR" in the where clause Informix couldn't figure >out that it could use the index and so did a full table scan. Oracle, Use a union instead, that is what they are for. >on the other hand, was able to use the index. There are other things >though that I like about Informix better than Oracle (Descending Indexes >come to mind). > >HTH >Ken Denny -- David Williams