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
What is a snapshot log?
Who developed oracle & when?
How to convert csv to table in oracle?
What is a tns service name?
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 ?
How to Truncate Table in Oracle
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?
What is oracle datasource?
What are a collation and state the different types of collation sensitivity?
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?
Explain what are the characteristics of data files?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What is redo log?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What do you understand by a database object? Can you list a few of them?