Have a report made in report services.
The dataset on this report is using a view.
The report is very very slow...
Have 9 parameters on this report
3 of the parameters is a int field, and the rest is
6 fields that are varchar fields, are filling up a listbox
with querys like:
Select Description2 from
(Select '<All cost centers>' As Description2, 1 as orderno
Select distinct Description2, 2 from SALG_STATISTIKKNEW2
ORDER BY orderno, Description2
So it take a long time to report to come up (1 time)
And are very slow, when ALL records (2 million) are selected
The report takes many minutes to execute...
So now i have converted the view to a TABLE, and have
created INDEX on every field that are used as parameter in the report.
See that the report execute faster now, but just improved by 100%
So the table is 2 times faster then using the view.
My question is:
Is it faster to drop the index on the varchar fields ?