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
how tsql statements can be written and submitted to the database engine? : Transact sql
What is set serveroutput on in pl sql?
What are the most important characteristics of pl/sql?
How exception handling is done in advance pl/sql?
What is an index in sql with example?
What does where 1 1 mean in sql?
Which is better join or inner query?
Which version of sql do I have?
What is oracle sql developer?
What is thread join () in threading?
What is a scalar value in sql?
What is the command used to fetch first 5 characters of the string?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is difference between ms sql and mysql?
How many sectors are in a partition?