What is an Index ? How it is implemented in Oracle Database ?
- 4 Answers
- 10759 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to install oracle odbc drivers?
Explain the different normalization forms?
Is there an oracle sql query that aggregates multiple rows into one row?
Explain overloading. Can functions be overloaded?
How to use "out" parameter properly?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How do I start tns listener?
How to start instance with a minimal initialization parameter file?
How many data types are supported?
How to use subqueries with the exists operator in oracle?
What is the quickest way to fetch the data from a table?
Is there a combination of "like" and "in" in sql?
how to handle exceptions in post production
Give the constructs of a package, function or a procedure.
What is a nested table and how is it different from a normal table?
