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
- 31141 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 define a variable of a specific record type?
Why does for update in oracle 8 cause an ora-01002 error?
What to do if dba lost the system password?
How to convert csv to table in oracle?
Explain the use of indexes option in exp command.
What is user managed backup in Oracle?
Which is better Oracle or MS SQL? Why?
Differentiate between function and procedure in oracle.
What is a proxy object?
Give the various exception types.
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What are the roles of dba?
What are the common oracle dba tasks?
What is max rowid in oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
