Improving query performance with views

Question

I have a large table with 10 + millions of records in a SQL Server database. The table contains data of a certain type for all 50 states in the USA. So, if I create 50 views, one for each state, from this table, will the query performance from my application be improved? Other offers?

Answer 1

No. A view is a macro that expands, so anyway the same table is included in the plan.

If it is not indexed. 50 indexed views are likely to exceed.

50 ( ), .

Edit:

dmv , ,

Answer 2

() - "" "" SELECT, .

- , , .

, , (, ).

, (, ).

Answer 3

:

, , , . , , , ( ).

Answer 4

, - . , /, .

Answer 5

One simple suggestion:

use [YourDataBase]
select * from sys.dm_db_missing_index_details as ddmid

Answer 6

This is such a tiny database that if you have performance problems, indexing incorrectly, the database design is poor, or you have developed poorly executed queries. SQL Server can process trillions of records without breaking sweat if they are designed correctly.

BTW views can be Killers performance if you use views that invoke views.