Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 191646 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 save query output to a local file?
Difference between inner join vs where ?
What is difference between truncate and delete?
What is oracle update statement with inner join ?
how to handle exceptions in post production
What are the parameters that we can pass through a stored procedure?
What are the differences between lov and list item?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to use fetch statement in a loop?
How do I spool in oracle?
How many types of auditing in Oracle?
How to use "in" parameter properly?
How to filter out duplications in the returning rows using oracle?
What is Undo Management Advisor in Oracle?
What are the oracle differences between nvl and coalesce
