SQL Server: Create index on view
09:01 13 Nov 2013

I created view on table and I'd like to create index on this view. When I created index only on view my query doesn't use index but when I create index on table and next the same index on view, query use index.

My view is creating new column based on other column with the same table which is based my view so I can't create index on table because i can't modify this table. It is possible created non clustered index on view which can improve my query? When I created non clustered index my query only table scan instead of use non clustered index.

sql-server indexing