Not able to create index on schema binding view

• jkramprakash

  SSCommitted

  Points: 1870

  More actions

  April 2, 2019 at 12:34 pm

  #2503433

  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, 11 months ago by  jkramprakash.

• ZZartin

  SSC-Dedicated

  Points: 30921

  More actions

  April 2, 2019 at 1:35 pm

  #2507793

  Indexed views can't reference other views, you'll have to put the nested view directly in the view you want to index.