Home » SQL & PL/SQL » SQL & PL/SQL » creating index on view (Oracle 9i)
creating index on view [message #381980] Tue, 20 January 2009 09:12 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Why we can't create view on Index?Please Give me the reason?
Re: creating index on view [message #381982 is a reply to message #381980] Tue, 20 January 2009 09:15 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.


>Why we can't create view on Index?
Problem exists between keyboard and chair.
Re: creating index on view [message #381983 is a reply to message #381980] Tue, 20 January 2009 09:16 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For the same reason you can't create an index on a query.

Regards
Michel

[Updated on: Tue, 20 January 2009 09:18]

Report message to a moderator

Previous Topic: executing a procedure
Next Topic: creating table in procedure
Goto Forum:
  


Current Time: Sat Dec 03 00:49:56 CST 2016

Total time taken to generate the page: 0.12856 seconds