Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between view and index
- 3 Answers
- 5983 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pravin patil
Vies is logical representaion of parent table
& index is oralce object use to access table' column quickly
view can replace but index cannot replace u have to delect
existed index then create new index.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sahaja mallarapu
A View is a data base object also called as virtual table
which is created on a select statement.
A view can be created using multiple tables.
A view is stored in a temporary memory.
An index is also a DB Object which is used to increase
query performance and index is created based on columns of
a table.
An index is created on multiple columns but on a single
table.
Index is maintained by Oracle Server itself.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / kamala k n
view is virtual table and index is created on table columns which is performance the query
| Is This Answer Correct ? | 0 Yes | 0 No |
What is an oracle recycle bin?
How can you Enforce Referential Integrity in snapshots ?
What is a table index in oracle?
What is oracle instant client?
How to revoke create session privilege from a user in oracle?
how to join query for one source type is oracle another source type is sql server ?
What is integrity and what is constraint??Explain with example
How can I combine multiple rows into a comma-delimited list in oracle?
What are the limitations oracle database 10g xe?
What is a connect identifier?
What is oracle open database communication (odbc)?
What is the difference between I and G in Oracle?
Oracle General 
