469,898 Members | 2,248 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

Create Index on View

rsrinivasan
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?

Thanks,
Aug 1 '08 #1
2 7098
debasisdas
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
ck9663
2,878 Expert 2GB
Debasisdas is right. If you have to, read

here


-- 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
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.