Tks all for your answers we will start making changes in some dev instances to verify behaviour. ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sandra Becker Sent: Jueves, 28 de Octubre de 2010 01:50 p.m. To: oracle-l@xxxxxxxxxxxxx Subject: Re: CHOOSE and ALL_ROWS 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.