Thanks so much GSquared! Using the temp table the query produced 5000 records in 24 seconds. I'm going to try the other suggestions as well.

Imu92,

Of the 3 joins in the view, 2 of the EINs actually contain chracters and are of the datatype nvarchar.

Thanks for your suggestions. I will try them along with...

I attached the execution Plan. The View is 'ORG_ALL'.

Here is the dbo.volunteerhours

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[VolunteerHours](

[ID] [int] IDENTITY(1,1) NOT NULL,

[SYS_EMP_ID_NR] [nvarchar](11) NOT NULL,

[REG_NR] [nchar](2) NULL,

[DIS_NR]...