How many different types of indexes we have in oracle?
- 24 Answers
- 185650 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
How to use "startup" command to start default instance?
Give the different types of rollback segments.
What is an oracle cursor variable?
What are the oracle built-in data types?
What is an oracle recycle bin?
What privilege is needed for a user to create tables in oracle?
What is an anonymous block?
How to use "out" parameter properly?
What is a relational database management system?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Which environment variables are absolutely critical in order to run the OUI?
Explain enable novalidate constraint.
What is a lookup table in oracle?
What are the roles of dba?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
