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 write ahead logging in sql server?
Does sql support programming?
What is the largest value that can be stored in a byte data field?
How can we optimize a sql query?
Is subquery faster than join?
List the various privileges that a user can grant to another user?
How many sql are there?
Can you join a table to itself?
Is left join inner or outer?
How do sql triggers work?
What are inner and outer joins examples of both?
Can we use two order by clause in query?
What are the subsets of sql?
How much does sqlite cost?
describe transaction-safe table types in mysql : sql dba