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 |
What is the usage of control file in oracle?
Explain what are clusters?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What are the attributes of cursor?
What is key preserved table?
There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep
what are the advantages of running a database in archive log mode?
What is an external table?
T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"
what is integrity constrains?