Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Oracle Database + Options
SQL and PL/SQL
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jul 11, 2005 12:40 AM by
How to create index on view
Jul 10, 2005 11:12 PM
Can I create an index on a view?I heard oralce has support this feature.
This content has been marked as final.
Show 1 reply
Re: How to create index on view
Jul 11, 2005 12:40 AM
in response to
A view is just a stored query, so it contains no data to index. Indexes would have to be created on the base table.
If your view were a materialized view, since the materialized view contains a copy of the data, you could create an index on it.
Distributed Database Consulting, Inc.