DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 11

Thread: Execution plan shows 3 times less CPU cost but query now takes 4 times more time

Threaded View

  1. #3
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    While I was traveling, I realized that I have not attached execution plans. The file is attached now.

    I will see the buffer gets once I have access to database servers again. I will share that information tomorrow.

    Next question is: Does the optimizer select execution plan solely on the basis of CPU cost?
    Attached Files Attached Files
    lucky

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