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

What is query image?

568


What are temporal data types in oracle?

586


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1740


what's query optimization and without use of IN AND Exist can we get another way data from query

1653


How can we create the complete backup of data in the oracle.

1672






How to select some columns from a table in oracle?

537


Explain coalesce function?

612


What is an oracle user account?

562


How to call a stored function in oracle?

563


What is a oracle database?

594


Explain the difference between sap and oracle?

566


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

585


What are the logical operations?

663


What happens if you use a wrong connect identifier?

491


Does facebook use oracle?

558