> I think that is still rather long. Can you update the execution > plan and index pages if you need it to go even faster?
You're right, it is still too long. And it turns out it's taking about 15 seconds on average, even slower than I thought. I updated the execution plan scrshot and the indexes as well. (I did add the index to all three applicable tables.) The link again is http:www.redmondinc.com/sos/index.html I had never seen your technique of using what looks like a subquery in the join segment of a query - I'm guessing further optimization is available using another one of those? In fact when I learn how to do that I bet I can apply similar tricks to most of my reports and really speed things up all across the app. The funny thing is, our company is so new to modern technology, people were buying me drinks just for getting them the data, even when hung the db server for 90 seconds. Maybe if I really get things humming they'll buy me a new car or something... (I have 2 sql books en route, by the way... "I'm not a slacker, I'm doin' the work. I'm babystepping.") Thanks again for your time and advice. -Paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189057 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
