What is an index and types of indexes. How many number of
indexes can be used per table ?
Answer Posted / rm thirunavukkarasu
Index is used to Retrive the Information in efficient
manner. And query processor perform reliably.
There are 3 types of Index namely
*Cluster based Index
*Non Cluster based Index
*Noncomposite Index
*Compositive Index
*Unique Index
For more info adt sql plz visit www.thiruna.blog.com
| Is This Answer Correct ? | 8 Yes | 16 No |
Post New Answer View All Answers
Is left join inner or outer by default?
What is a sql select statement?
Is sql microsoft?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is the life of an sql statement?
What is nvarchar in sql?
What is plpgsql language?
How does cross join work?
What is java sql package?
how to decrement dates by 1 in mysql? : Sql dba
Which one is better subquery or joins?
What is the use of %rowtype?
What are the possible values for the boolean data field?
How to run sql functions in pl/sql?
What is a primary key? Explain