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


Please Help Members By Posting Answers For Below Questions

How to convert a string to a date in oracle database?

548


What is a tns service name?

538


What is the minimum client footprint required to connect c# to an oracle database?

570


Explain alias?

717


What is Trigger in Oracle?

577






How many file formats are supported to export data?

661


What are the differences between char and varchar2 in oracle?

565


How to load data through external tables?

585


How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

2736


How to start instance with a minimal initialization parameter file?

542


What is data type in oracle?

568


How to write an inner join with the where clause in oracle?

587


What is a cursor variable?

580


Can we use bind variables in oracle stored procedure?

492


How many data types are supported?

624