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
- 31483 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 to add a new column to an existing table with a default value?
How to drop an existing table in oracle?
What are the restrictions on external table columns?
Can we convert a date to char in oracle and if so, what would be the syntax?
What is Trigger in Oracle?
What is catalog in Oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
Why should I use oracle database?
What is a table index in oracle?
How do we create privileges in oracle?
What operating systems are supported by oracle database 10g xe?
Explain oracle’s server parameter file.
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to start a new transaction in oracle?
What is oracle latest version?
