Answer Posted / sanjay mukati
Index is a such type of mechanism in which records are
searched and fetched efficiently and fastly in a table. It
is physical address of data.
Two type of index :
A. Cluster Index
B. Noncluster Index
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Can we return Data from 4(more than 1) tables in stored procedure?
What is bit data type? What's the information that can be stored inside a bit column?
How to use “drop” keyword in sql server and give an example?
Explain about protocol layer present in SQL server?
What are tables in sql server?
What is a performance monitor?
What is difference between equi join and natural join?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What is stored procedures?
Explain important index characteristics?
What is the difference between left and right outer join?
How connect excel to sql server?
How you can find out if an index is useful to the optimizer?
How to start and end transact-sql statements?
What is ddl and dml commands?