Answer Posted / 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 |
Post New Answer View All Answers
What is oracle used for?
How to get execution statistics reports on query statements?
What is truncate oracle?
How to create a single index for multiple columns?
How is it different from a normal table?
What is the Tune Query
query optmization techniques and quwry analyser+projects+ppts
How many file formats are supported to export data?
What are the attributes of the cursor?
What is flashback in Oracle?
Can we protect our pl/sql source code?
What is a dead lock in oracle?
List the types of joins used in writing subqueries?
What are the data types in oracle?
What are the uses of linked server and explain it in detail?
