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

Why do we use coalesce function in oracle?

603


What is primefaces used for?

540


What is a table index?

542


How do we display rows from the table without duplicates?

522


How to get the Installed Oracle Version Information ?

598






Explain the use of file option in exp command.

576


Explain the types of exception?

618


Why is oracle used?

529


What are the ansi data types supported in oracle?

496


What is execute immediate in oracle?

517


What are the differences between char and varchar2 in oracle?

538


How to open a cursor variable?

585


What is a database schema in oracle?

594


Use of an integrity constraint is better to validate data. Explain

515


What is a sub query? What are its various types?

557