Interested to Buy Any Domain ? << Click Here >> for more details...
What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 84285 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 are the types of join and explain each?
What is %s in sql?
How do I count rows in sql query?
What is anonymous block in sql?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Can cursors be part of a trigger body?
What are the commands used in sql?
Can we commit inside a trigger?
What are different types of functions in sql?
Is postgresql a nosql database?
What does the base_object_type column shows in the user.triggers data dictionary view?
What is the best sql course?
Explain the difference between triggers and constraints?
What is user in sql?
How do I find duplicates in a single column in sql?
