Interested to Buy Any Domain ? << Click Here >> for more details...
what are indexes..how many types of index's are there and
what are they?
- 7 Answers
- 31506 Views
- Green Info Solutions, TCS, I also Faced
- E-Mail Answers
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 many memory layers are in the oracle shared pool?
How to install oracle odbc drivers?
How to shutdown your 10g xe server?
How to execute a stored procedure in oracle?
how can we store any pdf file in oracle
What is a database schema in oracle?
Is there any function in oracle similar like group_concat of mysql?
How to assign values to data fields in record variables?
How to get last row id?
What is enter substitution variable in oracle?
various types of hints and their usage
How to execute the package in oracle?
How to use "in" parameter properly?
How do I start tns listener?
What is a user role in oracle?
