September 23, 2011 at 11:01 am
Yup, the best improvement I've seen is like 24 hours to 10 seconds, maybe even faster.
So I think 1 more round of tuning might prove interesting ;-).
September 23, 2011 at 11:20 am
Index Scripts as requested. I am over the moon with 12 secs, now I understand why I was obviously happy once with 39 mins. I like your enthusiasm for improvement...:)
There are some primary key clustered indexes already on the tables, the rest as created on the fly prior to running the individual scripts for fname01, 02 etc to 06. The attached indexes are created prior to running and dropped after. I look forward to learning your thoughts.
Monty
September 23, 2011 at 11:21 am
Thanks for the DDL, we still (and mostly) need to see the ACTUAL execution plan.
TIA.
September 23, 2011 at 11:39 am
I ran the execution plan as requested. It advised me to add a new index, which I did, time now 3secs.
Complete New index file attached, as well as execution plan as requested.
Monty
Viewing 4 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply