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
- 31461 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
List out the components of logical database structure of oracle database.
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How many categories of data types in oracle?
How does oracle handle read consistency?
What is concurrency in oracle?
What operating systems are supported by oracle database 10g xe?
How to assign values to data fields in record variables?
what is port in oracle? how is it related to database application.
What is the fastest query method to fetch data from the table?
Where do you use decode and case statements?
Explain the importance of .pll extension in oracle?
How to revoke create session privilege from a user in oracle?
What do you mean by a tablespace?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
What is the quickest way to fetch the data from a table?
