[dba-SQLServer] [AccessD] Optimizing Stored Procedures and Views

Thanks John,  I checked all the indexes and they seem to be the same.

David

At 3/04/2006, John Ruff wrote:
>Check your indexes in the tables that make up the views on the db that is
>running slow and compare them with the same tables in the db that is running
>fast. I'd venture to say you don't have one or more columns indexed in the
>slow db that should be indexed.