Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create index on views?
- 19 Answers
- 125160 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 pragma?
What is a synonym? What are its various types?
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
How to rename an index in oracle?
State and explain about oracle instance?
What are the data types in oracle?
Differentiate between pre-select and pre-query?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What do you mean by redo log file mirroring?
Can we create trigger on view in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How data locks are respected in oracle?
Oracle General 
