What is an Index ? How it is implemented in Oracle Database ?
Answer Posted / 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 |
Post New Answer View All Answers
how to make an oracle object
How to pass parameters to procedures in oracle?
What is oracle update statement with inner join ?
Which is better Oracle or MS SQL? Why?
what are archived logs?
How can we force the database to use the user specified rollback segment?
What is transport network substrate (tns) in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What is logical backup in oracle?
How to set up autotrace for a user account?
Calculate difference between 2 date / times in oracle sql?
master table and child table performances and comparisons in Oracle ?
how can we store any pdf file in oracle
How to add a new column to an existing table in oracle?
Why do you use stored procedures and state some of its disadvantages?