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
What is using in sql?
What is cross join example?
What is a stored procedure in sql with example?
What is the difference between left and left outer join?
What is meant by <> in sql?
What are different types of keys?
How do I view tables in mysql?
What is Difference Between Unique and Primary Key Constraints?
What are the different schemas objects that can be created using pl/sql?
Which one is better sql or oracle?
what is recursive stored procedure? : Sql dba
Explain the the update statement in sql?
what is blob? : Sql dba
Can a table contain multiple foreign key’s?
Explain character-manipulation functions?