Thanks.  I will read BOL.

After filling the table we don't update the index.

We have 51 databases that are constructed identically and we are querying all of them occasionally in a...

I don't think the issue is what Martha said for two reasons.

1. The table is used only for reporting and is never written to once it is created.
2. When I run

select...