Viewing 4 posts - 1 through 4 (of 4 total)
Following is the estimated SQL Plan:
https://www.dropbox.com/s/f69nsh46eij3ht0/LoadComExecutionPlan.sqlplan
As of now I think we are able to reach the crux of the issue, this db was ported from Oracle and we...
July 31, 2013 at 9:05 am
Thanks Kevin, we would be looking forward for the performance tuning sometime in the future once we have all the database components / schema in place, right now I am...
July 30, 2013 at 10:47 pm
Hi,
Issue resolved, our database has the auto create and update statistics on, so first time it was slow due to statistics creation and thereon since the optimum plan was generated...
April 17, 2013 at 2:11 am
Challenge here is that Query is not performing bad, in fact after first execution it takes less than 1 second, which is good, but I want it to revert back...
April 16, 2013 at 6:17 am
Viewing 4 posts - 1 through 4 (of 4 total)