Create Index on View

[rsrinivasan]

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,

[debasisdas]

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..

[ck9663]

Debasisdas is right. If you have to, read

here


-- CK