What is an Index ? How it is implemented in Oracle Database ?
Answer Posted / sawant
An index is a database structure used by the server to
have direct access of a row in a table.
An index is automatically created when a unique of primary
key constraint clause is specified in create table comman
(Ver 7.0)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to grant create session privilege to a user in oracle?
What language does oracle use?
What to do if dba lost the system password?
Where do we use decode and case statements?
What is transport network substrate (tns) in oracle?
Explain the use of record length option in exp command.
How to call a stored function with parameters?
What is a package in oracle?
What is an oracle database?
Explain the importance of .pll extension in oracle?
Whats the benefit of dbms_stats over analyze?
How to select some columns from a table in oracle?
When do we use group by clause in a sql query?
How to create a new table in your schema?
Explain the use of indexes option in imp command.