What is an index and types of indexes. How many number of
indexes can be used per table ?
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
What is snowflake sql?
differentiate between float and double. : Sql dba
What are the three forms of normalization?
How can one get sql*loader to commit only at the end of the load file? : aql loader
what is msql? : Sql dba
What is the use of prepared statement?
What is the difference between view and stored procedure?
Can a table contain multiple primary key’s?
What is loop in pl sql?
What is forward declaration in pl sql?
What is union and union all keyword in sql and what are their differences?
what tools available for managing mysql server? : Sql dba
What are the syntax and use of the coalesce function?
What is the difference between syntax error and runtime error?
what is a constraint? : Sql dba