PHYSICAL OR LOGICAL LISTING OF COLUMN TO SPEEDUP THE SEARCH IN A TABLE OR

What is Index and different types of Indexes?

Question Posted / manvendra

7 Answers
36228 Views
I also Faced
E-Mail Answers

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

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2462

What is varray?

1137

How can we find out the current date and time in oracle?

1090

How to pass parameters to procedures?

1034

What happens if the imported table already exists?

1033

What is the difference between substr & instr functions?

1229

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2971

What are internal user account in oracle?

1009

What is Java Pool in Oracle?

1171

What is the difference between $oracle_base and $oracle_home?

1089

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2116

How to rename an index in oracle?

1115

Explain the difference between sap and oracle?

1030

How to insert a new row into a table in oracle?

1165

How to handle a single quote in oracle sql?

1053