How many different types of indexes we have in oracle?

Answer Posted / ron

some more additions to the above:
context indexes etc. you can read about it here:
http://www.databasedesign-resource.com/oracle-indexes.html
hope this helps.

Is This Answer Correct ?    42 Yes 31 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a snapshot log?

797


Who developed oracle & when?

790


How to convert csv to table in oracle?

763


What is a tns service name?

761


what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2272


How to Truncate Table in Oracle

920


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2025


What is oracle datasource?

789


What are a collation and state the different types of collation sensitivity?

821


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2064


Explain what are the characteristics of data files?

850


why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1855


What is redo log?

839


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1892


What do you understand by a database object? Can you list a few of them?

827