Here is a reasoning exactly about that: http://jonathanlewis.wordpress.com/2008/11/11/first_rows_n/ Gints Plivna http://www.gplivna.eu 2010/10/26 Aragon, Gabriel (GE, Corporate, consultant) <gabriel.aragon@xxxxxx>: > Hi, > > I know that CHOOSE has to be removed in 10g and use FIRST_ROWS_n or > ALL_ROWS, but is it true that ALL_ROWS is only for DWH? anyone using > ALL_ROWS for a non DWH environment who can share behaviour? > > > tks > > > Gabriel > > -- //www.freelists.org/webpage/oracle-l