what are indexes..how many types of index's are there and
what are they?
Answer Posted / a.brahmam
indexes 5 tyeps
1.B-Tree index:-->in oracle by default index is called B tree index.
2.Bit map index:--->in oracle Bit map index is used to data warehouse applications generally Bit map index created low cardinality columns.
3.function based index:--->B tree index extension of the function based index.
in B tree indexes two type this are
4.Unique B tree index in oracle by default automatically created.
5.Non-Unique B tree index in oracle by default manually created.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use null as conditions in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is java oracle used for?
How to drop a stored procedure in oracle?
What do you mean by a deadlock?
How to write date and time literals in oracle?
Point out the difference between user tables and data dictionary?
What is a trace file and how is it created in oracle?
How to store only time; not date and time?
What are the different types of partitions in oracle?
What is the difference between post-database commit and post-form commit?
What is oracle rownum?
Explain joins in oracle?
What is hot backup and logical backup?
How to define a variable of a specific record type?