The first thing I noticed was that you're using a function as the first part of your WHERE clause. This makes it difficult for the optimizer to us an index. Off the top of my head I would index MSP_WEB_WORK.WWORK_START and MSP_WEB_WORK.WWORK_FINISH in the table and change the WHERE to:
MSP_WEB_WORK.WWORK_START BETWEEN '1/1/2008'
And '12/31/08 11:59:59 PM'
Do the same for the FINISH column.
It seems that you only want records in 2008 anyhow.
You may get a performance improvement if the query weeds out a lot of rows before applying other criteria.
Todd Fifield