Creating clustered index on view with COUNT in it

If you are in situation you have a view, but your tables have grown so much ( lets say above 5┬ámillion┬árecords) soon you will realize that queries that are used in your views consume too much I/O. The solution is to create index on that view. If you are using COUNT in your view you … Continue reading Creating clustered index on view with COUNT in it