How many different types of indexes we have in oracle?
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 convert a string to a date in oracle database?
What is a tns service name?
What is the minimum client footprint required to connect c# to an oracle database?
Explain alias?
What is Trigger in Oracle?
How many file formats are supported to export data?
What are the differences between char and varchar2 in oracle?
How to load data through external tables?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How to start instance with a minimal initialization parameter file?
What is data type in oracle?
How to write an inner join with the where clause in oracle?
What is a cursor variable?
Can we use bind variables in oracle stored procedure?
How many data types are supported?