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
What are the major difference between truncate and delete?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What privilege is needed for a user to insert rows to tables in another schema?
What is snapshot is too old? Give and example for better understand.
what are bitmap indexes? How does they work?
IS it possible to built the oracle database without setting the kernal parameters?
How to compare dates in oracle sql?
Can we save images in a database and if yes, how?
What is a user role in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Explain the use of record length option in exp command.
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to convert characters to dates in oracle?
What are the different oracle database objects?
How to use windows user to connect to the server?