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
Are sql connections encrypted?
how to convert character strings to numeric values? : Sql dba
What is sql trigger example?
What is sap sql anywhere?
What is t sql used for?
How to run pl/sql statements in sql*plus?
How will you distinguish a global variable with a local variable in pl/sql?
What is example of database?
Is record in pl sql?
Are sql database names case sensitive?
What are the different dml commands in sql?
Which is better varchar or nvarchar?
What are some emotional triggers?
What are the three forms of normalization?
How to start the command-line sql*plus?