I have been asked based on trace output to do analysis and performance optimization on some sql SP's that have the highest duration. The front-end is a high-traffic ecommerce web-site. Generally, my testing shows the data returns (in less than a second), sometimes 1-2 seconds - apparently this is NOT good enough for them. Not sure where to go next to try to increase this speed. When I turn on Exec Plan, I see that there is a temporary table variable that obviously does a table scan, but this is only 18% of 17% of the total query cost, and then 50% of 6% of the total query cost in the respective batches. Am I even looking at the right stats and is this the problem area? Everything else "looks" ok, for ex a 100% Clustered Index Seek - isn't this most desirable? Since I am not a Perf expert, please provide some insight and tips. (I guess they want result returned before they execute it  - joke) THX IN ADVANCE!