Re: Oracle is KILLING INFORMIX...

> Superior? Well, yes.... :-) > 1. If you walk through an index sorted ascending, > it may go quite fast. But if you turn the other way round > in a 4GL, you'll have to do a order by desc which will > (re)create a temporary index taking several minutes with > a few 100000 records in your table... In Oracle it won't. If this is a regular occurrence, there is nothing stopping you from creating a descending index or even mixing ascending and descending within one index.... > 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.... :-) -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Chief Cook and Bottlewasher The West Solutions Group | +------------------------------------------------------------------------------+ | (E) billy@west.co.za (U) http://www.west.co.za/billy.html | +------------------------------------------------------------------------------+ | Microsoft Word 6.0a to your mother .... | +------------------------------------------------------------------------------+