In the view object Tuning, in the frame called Retrieve from the database, I set
Only up to row number =10
I was expecting that only 10 rows would be retrieved from database by a filter like rownum<=10
but when I check the log (and database sql) I see that normal select is send to database:
So wouldn't it be better performance for me to just put rownum<=10 in the where clause?