Home » SQL & PL/SQL » SQL & PL/SQL » Index on a view
Index on a view [message #247982] Wed, 27 June 2007 13:31 Go to next message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

Is it possible to create an index on a view or would a view inherit the index of the table it is created from.
Re: Index on a view [message #247984 is a reply to message #247982] Wed, 27 June 2007 13:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not only it is not possible it is meaningless.
A view is just a query. How can you create an index on a query?
You create an index on the underlying objects.

Regards
Michel
Re: Index on a view [message #247990 is a reply to message #247984] Wed, 27 June 2007 14:15 Go to previous message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

thanks a lot just had some research and got the answer to that question.

Regards,
Kieron.
Previous Topic: Creating Function using NEXTVAL
Next Topic: Synonyms
Goto Forum:
  


Current Time: Mon Dec 05 23:59:07 CST 2016

Total time taken to generate the page: 0.07263 seconds