I have already rebuilt the indexes on each table affected by the query view. It did not help any. All the indexes, triggers and other procedures were restored and seem to be running. Though not at optimal speed as before the crash.

Thanks,

Don