What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 81310 Views
- Accenture, BirlaSoft, Cognizant, CTS, Symphony, I also Faced
- E-Mail Answers
Answer Posted / alekhya
index is a database object used for increasing the
performance.
types of indexes:
1)simple index
2)composite index
Unique index
composite unique index
bitmap index
key compression index
function based index
cluster index
non-cluster index
Reverse key index
| Is This Answer Correct ? | 12 Yes | 13 No |
Post New Answer View All Answers
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is the difference between partitioning and sharding?
What is the difference between clustered and non-clustered index in sql?
When you have to use a default "rollback to" savepoint of plvlog?
What are variables in pl sql?
How can we optimize a sql query?
what is 'mysqlshow'? : Sql dba
What is trigger and stored procedure in sql?
What is the maximum database size for sql express?
Write a sql query to find the names of employees that begin with ‘a’?
Why use triggers in sql?
What are different types of statements supported by sql?
What is clustered index sql?
What are the query optimization techniques?
What is data manipulation language?
