Re: Horrible Query Performance, Simple Query -- Performance Tuning Help Needed

Jonathan-

I'm not the 'owner' of this database, so I doubt that they will let us create a different table structure for anything. It looks like creating clustered tables or IOTs require that we recreate the underlying tables? The database was originally built by 3M, and I don't think we can make changes to the underlying structure, but only add indexes to it.

Is there any index that we could add to these tables that could speed them up?

Another idea we are thinking about is to create a materialized view based upon these tables. We could then put the appropriate indexes on the view to get the data we want quickly. However, we wanted to avoid having to do this.

Thanks for all your help everyone!

• Chad