Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 192546 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
What is a select query statement in oracle?
How do I reset a sequence in oracle?
What is clustered table in Oracle?
How to convert characters to numbers in oracle?
what are actual and formal parameters?
How to see free space of each tablespace?
What is a subquery in oracle?
what are archived logs?
How to use "if" statements on multiple conditions?
what are steps for interface? where is exchange rate defined in which table?
What is difference between truncate and delete?
What are a cluster and non-cluster index?
Why does Oracle not permit the use of PCTUSED with indexes?
What is system global area (sga) in oracle?
What is user managed backup in Oracle?
