Re: Improve Query

Thanks a bunch Arnie...



Arnie Rowland wrote:
I assume you have a good indexing strategy. Not knowing the quantity of data
involved, I would consider that for the first query, you 'should' have these
columns indexed:

type.application_request_status_type_id
req.application_request_status_type_id
req.application_id
req.application_request_id
app.application_id

And for the second, these additional columns indexed:

det.application_request_detail_status_type_id
det.status_desc
req.application_request_detail_status_type_id

And my name is 'Arnie' -NOT 'Arnold'. (How's Philly these days?)

Arnold,

[quoted text clipped - 45 lines]

Any help on this would be greatly appreciated, thanks :)

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-mseq/200611/1

.