Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between view and index
- 3 Answers
- 6038 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 are views?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
How to create a stored function in oracle?
Can multiple cursors being opened at the same time?
Describe the types of sub query?
Explain oracle left join with an example?
What is Private Database Link ?
What is currency type in database ?
How to define a procedure inside another procedure?
What are the various oracle database objects?
What is a proxy object?
What privilege is needed for a user to create tables in oracle?
Oracle General 
