You're right, they are all non-clustered.

No, unfortunately, we really don't have an in-house DBA - hence my trying to get some insight here. We have a person that 'runs' things for us but they really...

No, I am just a developer w/ dbo. Maybe that makes a difference?

When I do this....

select * from master..sysprocesses

I just get one row.

When I do this:

SELECT spid, blocked, waittime, lastwaittype FROM master..sysprocesses

where SPID = 81

I get:

8100MISCELLANEOUS ...

"Also, during the day, run this query and check the wait_state for the SPID and see what you get. It'd help to know why it thinks it's stuck. "

I apologize...

Here are the indexes:

However, just running the primary select statment just then took me 1:17 to return 14,765 rows. BUt, again, am I barking up the wrong tree if I...

Here's where I created the view OK:

CREATE VIEW [dbo].[RTV_CURRENT_TRIP] (car_init, car_no, maxRTTRIPshipdatetime)

WITH SCHEMABINDING

AS

SELECT RT_TRIP.car_init, RT_TRIP.car_no, max(RT_TRIP.ship_date_time) maxRTTRIPshipdatetime

FROM dbo.RT_TRIP

GROUP BY RT_TRIP.car_init,

RT_TRIP.car_no

But I get an error when trying to create a...

I can research how to do this. In essence, just replace my current view by creating an indexed view?

I tried to create an index on the view but it wouldn't let me - I can't remember the msg I got. Is this what you are recommending? If so,...

OK Thank you - I'll give it a try.

I added the index you suggested and no noticeable difference. I will drop it then add it again tomorrow and test when the users are hitting the DB harder to...

OK, maybe I'm off on the wrong track here and someone can help me. The query I am running is coming from a proc. When I first ran the proc...

I've attached the exec plan. Is there a way to do the indexes easily or do I have to do them 1 by one?

There are 15 Non-Unique, Non-Clustered indexes on RT_TRIP. I don't know how to get the execution plan in text - in only shows up graphically.

***** RT_TRIP DEF

CREATE TABLE [dbo].[RT_TRIP](

[car_init] [char](4)...

Duh...sorry, didn't realize it was that simple. Thanks.