Loading ...
Sorry, an error occurred while loading the content.

121033Re: Why the difference?

Expand Messages
  • Dmitry Yemanov
    Mar 1, 2013
      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
    • Show all 18 messages in this topic