How many different types of indexes we have in oracle?
- 24 Answers
- 185648 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / rohit
In Oracle there are two types of SQL index namely, implicit and explicit.
Implicit Indexes:
They are created when a column is explicity defined with PRIMARY KEY, UNIQUE KEY Constraint.
Explicit Indexes:
They are created using the "create index.. " syntax.
NOTE:
1) Even though sql indexes are created to access the rows in the table quickly, they slow down DML operations like INSERT, UPDATE, DELETE on the table, because the indexes and tables both are updated along when a DML operation is performed. So use indexes only on columns which are used to search the table frequently.
2) Is is not required to create indexes on table which have less data.
3) In oracle database you can define up to sixteen (16) columns in an INDEX.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is oracle a language?
Difference between pre-select and pre-query
What are the uses of synonyms?
What are data pump export and import modes?
What is system global area (sga) in oracle?
How to delete a column in an existing table in oracle?
What is rich query?
What is the usage of save points in oracle database?
How to view the data files in the current database?
What is an oracle recycle bin?
What is a data dictionary and how can it be created?
What is procedure overloading in oracle?
Explain an extent?
What is connection pooling in oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
