Can we create index on views?
- 19 Answers
- 119984 Views
- CTS, Syntel, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramon
With schemabinding
the view have to be attache with schemabinding on it. Yes it is possible
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mahesh kumar
we can never create index on view, becasue view doesn't
have physical memory. If we try to create index on view in
oracle, produce error: a view is not appropriate here
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / hafiz
Yes we can create index on a view becuase the view may be
creates on subquery also and then the retrival of records
may be complex and therefore there must be an index on that
perticular column.
| Is This Answer Correct ? | 16 Yes | 17 No |
Answer / siva
no we cann't create an index on a view.why because view is
a virtual table.when u select the view it will get the data
from base(database)table.
view is a stored query.so we cann't
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / dibya tara shakya
No we cannot create index in views. As view are virtual
table based on multiple or single static tables.
View are create and execute only if there is select
privilege in base table to create view .
Triggers are also create in views.
But we can treat a view a table which make ease to gather
the data from different tables. we can insert data from
views only if the view are created from single table.
| Is This Answer Correct ? | 23 Yes | 34 No |
What are triggers in oracle?
Where are the settings stored for each instance in oracle?
How many types of synonyms in Oracle?
How to retrieve the count of updated rows?
How to rename a column in an existing table?
What are virtual columns?
How do I limit the number of rows returned by an oracle query after ordering?
waht is the difference between primary key and super key?
How to create a table in a specific tablespace?
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
What are the differences between date and timestamp in oracle?
How to write text literals in oracle?
Oracle General 
