Interested to Buy Any Domain ? << Click Here >> for more details...
what are indexes..how many types of index's are there and
what are they?
- 7 Answers
- 31156 Views
- Green Info Solutions, TCS, I also Faced
- E-Mail Answers
Answer Posted / rudrab123
An index is a listing of keywords accompanied by the
information of location of the subject.
in a SQL statement, if there is no Where clause then there
is no index.
In Oracle 8i,
there are 4 types of indexes .They are:-
1.B-Tree Index
2.Bitmap Index
3.Unique index
4.Function based index.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How to create a temporary table in oracle?
What is data file?
How oracle handles dead locks?
What would you do with an in-doubt distributed transaction?
Explain the use of file option in exp command.
Why oracle is used?
How to use null as conditions in oracle?
Explain the difference between sql and oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
Can we write dml statement in function in oracle?
Explain the difference between replace() and translate() functions in oracle?
What is oracle rownum?
How to count groups returned with the group by clause in oracle?
How to invoke the data pump export utility?
Why is oracle database so popular?
