Re: Oracle is KILLING INFORMIX...

@augsburg.net 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 >which is supported by a fitting index, you can say in >Oracle I can't speak to the first issue but at the IWUC in Chicago there was a session on new functionality of the OnLine Dynamic Server engine. This was one of many new and exciting pieces of technology that are in beta right now for general release in the very near future. Those who couldn't attend the conference ought to talk to their local sales office to get a copy of the proceedings of this session. Just the discussion on new index technology is worth the effort. Not to bash a competitor but Red Brick with their "Star Indexes" will be road kill when you can have table-less indexes, multi-table indexes and more. Oh and they're all bitmap indexes too. Carlton ______________________________________________________________________ Carlton Doe "It's not *over* until I win!" DBA Resources, Inc. -- Les Brown Salt Lake City, UT dbaresrc@xmission.com http://www.xmission.com/~dbaresrc carlton@errin.dbaresrc.com PGP key: finger -l dbaresrc@xmission.com