• 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