Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between view and index
- 3 Answers
- 6114 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 a tns file?
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
How to convert a string to a date in oracle database?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
How to recover a dropped index?
Will you be able to store pictures in the database?
What is set verify off in oracle?
structural difference between bitmap and btree index ?
what is trigger?
Difference between cartesian join and cross join?
What is tns entry?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
Oracle General 
