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
Is primary key a clustered index?
How do you optimize a stored procedure in sql?
Is left join faster than inner join?
how do you know if your mysql server is alive? : Sql dba
What is where clause in sql?
How many columns should be in an index?
What is sql and explain its components?
what are date and time functions in mysql? : Sql dba
Is postgresql a nosql database?
Why is sql important?
How long will it take to learn pl sql?
What is delimiter sql?
What is the best sql course?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Explain what is sql*plus?