Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 193423 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / shankar
1.B-tree indexes:
B-tree indexes have the following subtypes:
Index-organized tables
Reverse key indexes
Descending indexes
B-tree cluster indexes
2.Bitmap and bitmap join indexes
3.Function-based indexes
4.Application domain indexes
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by a deadlock?
How to calculate date and time differences in oracle?
How to see the table columns used in an index?
State some uses of redo log files?
Explain the use of indexes option in exp command.
Explain how you would restore a database using RMAN to Point in Time?
How to define an oracle cursor variable?
how may join possible between (requisition with purchase order)
What are joins, explain all types of joins?
Give the different types of rollback segments.
Explain table?
Explain the use of file option in exp command.
Please explain oracle data types with examples?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
