What is Index and different types of Indexes?

Answer Posted / suresh somayajula

Index is used to solve some query fast.

we have 2 types of cursors.
1 Bitmap Index ( used only on Low cardinality columns)

2. Btree Index ( used only for High Cardinality of

columns)

Is This Answer Correct ?    8 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to test null values?

845


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.

2147


How to convert character types to numeric types?

777


Can we connect to ORACLE db using Windows Authentication?

932


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1722


What is dual table oracle?

708


How do I manually create a database in oracle?

743


How to estimate disk space needed for an export job?

760


what is reindexing?

1349


What is meant by joins? List out the types of joins.

717


Describe an oracle table?

797


How do I find my oracle client driver version?

734


How to create a new user account in oracle?

784


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

781


Can you have more than one content canvas view attached with a window ?

2049