How many different types of indexes we have in oracle?
Answer Posted / swapna
We have mainly two different indexes .
Implicit index and Explicit index.
Explicit indexes are again of many types like
simple index,unique index,Bitmap index,Functional
index,Organisational index,cluster index.
Is This Answer Correct ? | 179 Yes | 64 No |
Post New Answer View All Answers
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Who developed oracle & when?
What do you mean by merge in oracle and how can we merge two tables?
Does oracle partitioning improve performance?
Explain the use of indexes option in imp command.
What is an oracle?
How can we view last record added to a table?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
When do we use group by clause in a sql query?
How will you identify oracle database software release?
Explain the difference between sap and oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is a user role in oracle?
How to create a temporary table in oracle?
What is a package ? What are the advantages of package ?