Inconsistent timings
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Inconsistent timings

  1. #1
    Join Date
    Apr 2001
    Posts
    112
    Hi
    Im trying to optimize a query , the last I worked on it the timing got reduced to 4 minutes. I noted down the exact query plan the tuned stmt was using. Now I try to run it it is taking around 20 minutes, even though it is using the same access plan. THe data hasn't changed. Is there something Im missing?


    Thanks

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Is the tables analyzed?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width