There are many queries that go from running in 15mins to 6 hours after about 10 days. The queries are all based on joining of many views. Each of those views many up of many extremely wide tables.

I took a close look at one particular query. First, I tried to make sure I had updated statistics. No affect. Next, I rebuilt the indexes for that query. It returned to a 15min query.

I rebuilt indexes once a week for 3 weeks. The query ran consistently in 15 min. Then I rebuilt indexes for the entire schema. All queries run consistently in 15min.

There is nothing I can do about the SQL. I've been told it cannot be changed.

Database is size 150gb.


Hoz