Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 192514 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
What are nested tables?
What is connection pooling in oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to bring a tablespace offline?
What is the difference between substr and instr?
What is the use of aggregate functions in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is the usage of analyze command in oracle?
What is oracle host variable?
Why is oracle so popular?
What are the advantages of oracle 12c?
How to recover a dropped table in oracle?
How to loop through data rows in the implicit cursor?
How to add a new column to an existing table with a default value?
What is Trigger in Oracle?
