How many different types of indexes we have in oracle?

Answer Posted / nagaraju

We have mainly two different indexes .

Implicit index and Explicit index.

Explicit indexes are again of many types like
simple index,unique index,Bitmap index,Functional
index,Organisational index,cluster index.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2890


How to resolve name conflicts between variables and columns?

576


How to drop a stored function?

680


What is recycle bin in Oracle?

722


How to use "in" parameter properly?

621






How can you merge two tables in oracle?

572


hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1567


types of indexes and the rationale behind choosing a particular index for a situation.

1986


State and explain about oracle instance?

551


Explain the use of inctype option in exp command.

598


How many data types are supported?

624


How to assign query results to variables?

594


How does one get the view definition of fixed views/tables?

607


nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

1745


How to create a new oracle data file?

563