Differnce between view and index
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 a Data Dictionary ?
How to see free space of each tablespace?
How to define an anonymous procedure without variables?
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
Shall I get Pro*C Compiler in Oracle-10g release ?
What is the maximum number of triggers that can be applied to a single table?
What is an Index ? How it is implemented in Oracle Database ?
What is an oracle user role?
What is an oracle transaction?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
what is the use of composite key constraint?
What is blob data type in oracle?