Can we create index on views?
- 19 Answers
- 122554 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 is a snapshot log?
Is primary key indexed by default in oracle?
what is query and types of query
What is the difference between implicit index and explicit index?
difference between procedures and function?
Which is better Oracle or MS SQL? Why?
Please explain joins in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Where are the settings stored for each instance in oracle?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
How to get execution path reports on query statements?
Oracle General 
