Re: Ultimate Question: Oracle, MSSQL, Others vs MYSQL LIMIT Statement

Naturally my knowlegde of Oracle is mostly book-smarts.... http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/em.920/a86647/reorg.htm#1006543 I'm not sure why Oracle would spend money on features that aren't useful in one way or another.

Howard, please note that this thread has in no means been an attack on any product, nor on the relative need for reorg between produts. However minuscule the need for reorg of some sorts is in any given product (inluding Oracle) it exists and that makes reorg one of the many reasons to stick to separation of an abstract access to the data withot exposing any physical properties.
.. which coincidently was is the topic of this thread.

Now if you insist we can cut out all the other cross-posted groups and turn to a reorg war in the Oracle newsgroup.

Cheers
Serge

-- 
Serge Rielau
DB2 UDB SQL Compiler Development
IBM Software Lab, Toronto

Try the DB2 UDB V8.1 beta at
http://www-3.ibm.com/software/data/db2/