What is an Index ? How it is implemented in Oracle Database ?
Answers were Sorted based on User's Feedback
Answer / guest
Index is an Oracle SQL object which we create to speed up
the query performance.
It is created automatically on those columns which contains
primary key or unique key.
We can also create the index manually by using create index
command.
Max 16 indexes can be defined per table.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / ankur jain
An Index is nothing, it is something like the index behind in your text book, using index we can find any topic in our text book very fast,, hence database index is also like that, oracle engine uses this index to find any particular row quickly..
This is automatically created when you create the primary key during creation of table..
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
How to convert dates to characters in oracle?
What is varray?
What is the data type of dual table?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
what is normalisation?what are its uses?
How data locks are respected in oracle?
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
What is execute immediate in oracle?
What is a cursor in oracle?
What is recovery manager in Oracle?
how to join query for one source type is oracle another source type is sql server ?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls