Not able to create index on below schema binding view.It is created from another view(v_prod_manu_sub).I am using this view in my join statement of query.It is showing below error msg 'Cannot create index on view "dbo.V_PROD_MANU" because it references derived table "X" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.'how to change this below query for index creation.?
- This topic was modified 5 years, 8 months ago by jkramprakash.