Here is the sequence of things that have occurred and/or a summary of the information:

1. I am working with a vendor's backend system, using that data to do analysis....

I will take a look at table partitioning as a read, but I don't think that is going to help me out. Since the vendor owns the schema, I...

Umm, sorry. I didn't realize this was the SQL 2k forum. I just joined when I posted this. Many apologies for that.

Just so you guys don't go too far off track, I am working in a SQL 2k5 environment, not 2k...

Demetrius

Thanks for your help Gail!!

Gail - I wanted to clarify that I wasn't waiting on a second opinion, I was waiting on another round of feedback from your...

Attached is the execution plan in...

I agree that's a wide index. Sorry, for not making this clear in the original request. My original index was on [Company_No],[Period],[Year_For_Period] and incredibly the performance between that...

The SQLPlan is attached and here is the index:

USE [GLDemo]

GO

/****** Object: Index [BizTransIDX] Script Date: 11/12/2009 12:01:00 ******/

CREATE NONCLUSTERED INDEX [BizTransIDX] ON [dbo].[GL]

(

[Company_No] ASC,

[Year_For_Period] ASC,

[Period]...