How many different types of indexes we have in oracle?
- 24 Answers
- 188662 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / satya krishna
B-TREE INDEX, BITMAP INDEX, REVERSE INDEX, FUNCTION-BASED INDEX, ASCENDING & DESCENDING INDEX, Cluster indexes, bitmap join indexes, text indexes, Hash cluster indexes, DOMAIN INDEXES.
Indexes are logically and physically independent of the data in the associated table.
ONCE AFTER CREATING THE INDEX ORACLE WILL AUTOMATICALLY HANDLE IT LATER.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
How to start your 10g xe server?
Is oracle an open source?
Why oracle is used?
Hi Can any one tell me what are the API's used in requisition import.
What is user managed backup in Oracle?
What is transport network substrate (tns) in oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is the usage of save points in oracle database?
What are the extensions used by oracle reports?
How to connect to a local oracle 10g xe server?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Is oracle a language?
Explain the use of inctype option in exp command.
What is the difference between 10g OEM and 11g OEM?
does the query needs a hint to access a materialized view?
