What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 79266 Views
- Accenture, BirlaSoft, Cognizant, CTS, Symphony, I also Faced
- E-Mail Answers
Answer Posted / guest
Index is a method used for faster retrieval of
records.different types of indexes are
1.primary key index
2.unique index
3.bitmap index
4.hash index
5.function based index
6.B-tree index(default index created) on table.
7.Virtual index(which do not show entry in DBA_segment).
| Is This Answer Correct ? | 128 Yes | 35 No |
Post New Answer View All Answers
What is varchar sql?
What is pl sql in dbms?
What will you get by the cursor attribute sql%notfound?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Explain table and field in sql?
What are the types of subqueries?
how to rename an existing column in a table? : Sql dba
Is nosql relational?
What is sql exception?
Do we need commit after truncate?
What is the use of <> sql?
How does sql developer connect to oracle database?
What is t-sql? : Transact sql
What is database white box testing and black box testing?
Which is better stored procedure or query?
