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 define an explicit cursor in oracle?
What are the varoius components of physical database structure of oracle database?
What is a sub query and what are the different types of subqueries?
How to retrieve values from data fields in record variables?
What do you understand by a database object?
How to invoke the data pump import utility?
What is the database name in oracle?
How to manage transaction isolation level?
How to drop a stored function?
How to store only time; not date and time?
What is literal?
How to Truncate Table in Oracle
Explain the use of grant option in exp command.
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??