Howto improve performance for these queries, why is my indexed view making it worse for most of them and how can I change that?
for the record, this is a rewrite of the following question (you do not have to read that because I include all important data here) Howto improve performance for queries against table without primary ...
Howto improve performance for queries against table without primary key without changing the query or the table directly? [closed]
UPDATE: I included some updated information in this question, because there was no way of progressing here given the previous constraints. Scroll to the bold-faced paragraphs to see my updates; I ...