Answer Posted / orawhiz
An Index is an optional structure associated with a table to
have direct access to rows,which can be created to increase the
performance of data retrieval. Index can be created on one
or more columns of a table.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to test null values?
Explain the use of grant option in exp command.
What are the set operators union, union all, minus & intersect meant to do?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
Explain integrity constraint?
What privilege is needed for a user to create tables in oracle?
How many types of cluster table in Oracle?
What is a cursor and what are the steps need to be taken?
Please explain compound trigger in oracle?
Who developed oracle & when?
master table and child table performances and comparisons in Oracle ?
How to execute a stored program unit?
What is truncate oracle?
Describe varray?
How to use group functions in the select clause using oracle?