121033Re: Why the difference?
- Mar 1, 201301.03.2013 8:37, W O wrote:
> I have a table with 3.600.000 rows more or less.Please show us the query plans.
> SELECT * FROM V_ABM_PERSONAS V WHERE V.PER_IDENTI > 0 ROWS 1 TO 100
> takes 2.656 seconds (less than 3 seconds)
> 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)
- << Previous post in topic Next post in topic >>