472,139 Members | 1,700 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,139 software developers and data experts.

Create Index on View

221 100+
Hi all,

I want to create index on view. Is it posiible? When i create index on view, it throws the error Cannot create index on view 'q_Invoices_Issued' because the view is not schema bound.. What is the solution for it?

Aug 1 '08 #1
2 7185
8,127 Expert 4TB
you are supposed to create index on table not views because view does not store data physically and can be union of a number of schemas..
Aug 1 '08 #2
2,878 Expert 2GB
Debasisdas is right. If you have to, read


-- CK
Aug 1 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by PaT! | last post: by
2 posts views Thread by Shirley | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.