How many different types of indexes we have in oracle?

Answer Posted / srinivasarao

total indexes are in oracle is 5
1.b tree
2.bitmap
3.function_based
4.domain
5.ascending or descending

Is This Answer Correct ?    27 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What exactly do quotation marks around the table name do?

544


What is oracle instant client?

566


> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

1569


What is raw datatype?

593


What are the uses of linked server and explain it in detail?

586






State and explain about oracle instance?

551


How to define an oracle sub procedure?

597


Is oracle an open source?

637


What is private procedure oracle?

529


What are internal user account in oracle?

571


What are the different windows events activated at runtime ?

2410


query optmization techniques and quwry analyser+projects+ppts

1932


What is hash cluster in oracle?

596


What language does oracle use?

598


How to call a sub procedure?

562