What's the defination of your View? You cannot index all kind of views. There are some rules you need to follow. Copy your View defination here and I will be able to tell you why.
>I created a view in the Create schema sql and then tried to index it.
>I received the message.
>Cannot create index on view 'vw_SMPaper_Orders_LineItem_Inventory'
> because the view is not schema bound.
>how do I bind my view to a schema.
>
>Thanks
>Jim
- Jayesh