01.03.2013 8:37, W O wrote:

> I have a table with 3.600.000 rows more or less.
>
> Writing:
> SELECT * FROM V_ABM_PERSONAS V WHERE V.PER_IDENTI > 0 ROWS 1 TO 100
>
> takes 2.656 seconds (less than 3 seconds)
>
> Writing:
> SELECT * FROM V_ABM_PERSONAS V ORDER BY V.PER_IDENTI ROWS 1 TO 100
>
> takes more than 11 minutes!!!! (bored, I did cancel the execution)

Please show us the query plans.


Dmitry