Re: Oracle is KILLING INFORMIX...

} }In article <4uogfd$qab@sparcserver.lrz-muenchen.de>, ?@?.? writes }>In <4s97jk$o0c@nadine.teleport.com>, markb@raysfood.com (Mark Blum) writes: }>>Mike: }>> }>>... }>> }>>Informix may have had a superior product, ... }>> }>> }>>Rick Creson }>> }> }>Superior? }> }>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. }> } } I'd need to check this and get back to you. } Informix ODS 7.2 adds support for bi-directional indexes. Gary McCracken Informix Software, Inc. Five Concourse Parkway, Suite 1500 Atlanta, GA 30328 Office (770) 395-2319 Fax (770) 395-2305