What is an Index ? How it is implemented in Oracle Database ?
Answer Posted / nishi
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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to manage transaction isolation level?
how to make an oracle object
How to convert csv to table in oracle?
How to select some columns from a table in oracle?
What is an Oracle index?
What do database buffers contain?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is the maximum limit on the number of columns in a table?
What do you mean by merge in oracle and how can you merge two tables?
What is materialized view in Oracle?
How to create a temporary table in oracle?
Can the query output be sorted by multiple columns in oracle?
List the types of joins used in writing subqueries?
How to store pictures on to the database?
How to create a new table in your schema?