How many different types of indexes we have in oracle?
- 24 Answers
- 187127 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / gaurav kukreja
mainly two type of indexes
1:- logical
2:- physical
logical indexes are also two type.. uniqe and functional
based indexes.
functional indexes are also two type...b-treeand bit map
indexes....
indexes are also used in searching and sorting
| Is This Answer Correct ? | 13 Yes | 11 No |
Post New Answer View All Answers
How to start an oracle instance?
What happens if the imported table already exists?
What are the original export and import utilities?
Can we use bind variables in oracle stored procedure?
Compare and contrast between sql and sql server and explain its various functions?
How many memory layers are in the oracle shared pool?
How can Oracle users be audited?
Is oracle a relational database?
What are the execution control statements in oracle?
How to pass parameters to procedures?
What is the recommended interval at which to run statspack snapshots, and why?
How to use group functions in the select clause using oracle?
How to sort output in descending order in oracle?
Which is faster join or subquery in oracle?
In oracle there is column command, how will you explain that?
