What is Index and different types of Indexes?

Answer Posted / manvendra

PHYSICAL OR LOGICAL LISTING OF COLUMN TO SPEEDUP THE SEARCH
IN A TABLE OR VIEW IS CALLED INDEX.

FUNCTION BASED INDEX
HASH INDEX
BITMAP INDEX
COMPOSIT INDEX
B TREE INDEX

Is This Answer Correct ?    8 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create an oracle database manually?

791


What is a nvl function? How can it be used?

745


How to loop through a cursor variable?

782


Explain what are the uses of rollback segment?

762


What is where clause in oracle?

755


What is open database communication (odbc) in oracle?

712


what is the scenario where you take the database to NoArchivelog mode?

2049


How to use "startup" command to start default instance?

729


How do I manually create a database in oracle?

733


How to run the anonymous block again?

818


How to use windows user to connect to the server?

720


Can we write insert statement in function in oracle?

790


Point the difference between translate and replace?

813


Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1761


Why cursor variables are easier to use than cursors?

769