How many different types of indexes we have in oracle?
Answer Posted / gnskannan
Indexes in Oracle are as follows.....
1.Normal index
Whenever we created a column(s) with Primary key or
Unique constraints ,Oracle implicitly creates Normal
index.This index is not Unique index .Why because those
columns already having uniqeness because of Unique or
Primary key constriants.
2.Bitmap indexs
3.Function based indexs
4.Domain indexes.
if we want to create Unique indexes we have to use Unique
keyword when we are creating indexes.
But if you refer Oracle 9i corporation books you can read
as follows...
They gave these statement in wrong.
Indexes can be created in two types
1.Unique indexes(Oracle creates it implicitly whenever we
created column(s) with PK or Unique constraints
2. Non unique indexes
This indexes can be created by developers
Is This Answer Correct ? | 83 Yes | 28 No |
Post New Answer View All Answers
What do you mean by merge in oracle?
Whether any commands are used for months calculation? If so, what are they?
Point the difference between translate and replace?
What is a trace file and how is it created in oracle?
What is the difference between postgresql and oracle?
Explain the features of oracle?
What are the different types of trigger and explain its various uses and functions?
Explain an index?
What is control file used for?
What is PL/SQL ?
How to rollback the current transaction in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What is proxy method?
What is primefaces used for?
How to execute a stored program unit?