How many different types of indexes we have in oracle?
Answer Posted / nagaraju
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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is connection pool in oracle?
How to initialize variables with default values?
Please explain oracle left join with an example?
List the types of joins used in writing subqueries?
What is an oracle user account?
In oracle there is column command, how will you explain that?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is a named program unit?
Why oracle is used?
What is oracle used for?
How to sort the query output in oracle?
How to shutdown your 10g xe server?
What is the usage of synonyms?
What is where clause in oracle?