Differnce between view and index
- 3 Answers
- 6303 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 the string concatenation operator in oracle?
What is rowid and rownum in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is a cognitive schema?
What are the composite date types in oracle?
what is the difference between first normal form & second normal form?
select statement does not retrieve any records. what exception is raised?
what is the syntax of INSERT command?
What are privileges and grants?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How to concatenate two text values in oracle?
What is execute immediate in oracle?
Oracle General 
