3 Replies Latest reply: Mar 4, 2014 3:53 PM by gandolf999 RSS

    Same Query is taking different time intervals


      I have a scenario, in which i have one stored proc which contains set of sql statements( combination of joins and sub queries as well, query is large to displays) and finally result is storing in temp table.

      this is executing by user from frontend or programmer from backend with specific permissions.

      here the problem is, there is difference in execution time for this query.

      sometimes it is taking 10 mins, sometimes it is taking 1 hour, but an average elapsed time is 10 mins, and one common thing is always it is giving the same amount of records (approximately same).