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
- 31745 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 clone 9i Database on to 10g Database.
What is the difference between a primary key & a unique key?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Can we call procedure inside function in oracle?
How to define a data source name (dsn) in odbc manager?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What is Library Cache in Oracle?
How to handle a single quote in oracle sql?
How to update values in a table in oracle?
How to change program global area (pga) in oracle?
Can we write insert statement in function in oracle?
How to create additional tablespaces for an new database?
Please explain oracle left join with an example?
Explain an index segment?
Difference between the “verify” and “feedback” command?
