Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create index on views?
- 19 Answers
- 125817 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 the restrictions in a oracle read only transaction?
How to see free space of each tablespace?
Explain do view contain data?
How to view existing locks on the database?
What is MTTR advisor in Oracle?
What is indexing, and how does it improve performance?
Describe an oracle table?
What are the data types in oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
Please explain oracle data types with examples?
Oracle General 
