We use ALL_ROWS and we do not have a data warehouse. The way our application is written, for better or worse, it will not perform well using FIRST_ROWS_n. Test, test and test all aspects of your application before making the change. Sandy Transzap, Inc.