Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between view and index
- 3 Answers
- 6223 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 shell?
What is a read only transaction in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
what is the difference between restoring and recovering?
How to increment dates by 1 in oracle?
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
What is the exact use of Collections?
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
What do you mean by merge in oracle and how can we merge two tables?
Explain the concept of the DUAL table.
What is private procedure oracle?
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
Oracle General 
