4 Replies Latest reply on Jan 23, 2018 8:53 AM by fac586

    Why does a query respond in two different times, while nothing changes.



      i create view like

      "select col1,col2,col3 from table where user=v('APP_USER')"

      when run query first time

      "select count(*) from view "

      the time is 0.02 s but

      next I will run the same query again

      "select count(*) from view"

      Time changes to 8 seconds,Again when compiling it ,Time is 0.2 seconds and next query is 8 second.