What is an Index?

Posted by Neeks on 3/31/2009 | Category: Sql Server Interview questions | Views: 6087

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

When queries are run against a db, an index on that db basically helps in the way the data is sorted to process the query for faster and data retrievals are much faster when we have an index.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What command do we use to rename a db?

Next > : What is a Stored Procedure?

Comments or Responses

More Interview Questions by Neeks

What is a Stored Procedure?
What is the maximum limit for Primary Key?
What is the Difference between Web.config and Machine.config?
What are the advantages and disadvantages of Cookies?
What is Cookie Dictionary?
What is the difference between Session Cookies and Persistent Cookies?
Explain about Data access objects or DAO?
Explain about the relationship of XML and ADO.NET?

Latest Interview Questions

Default Access modifiers in C#?
What is Protected Internal access modifier in C#?
What is Internal access modifier in C#?
What is Private access modifier in C#?
What is Public access modifier in C#?
What is Protected access modifier in C#?
Can we specify the access modifier for explicitly implemented interfac ...
What is the use of @@TRANCOUNT in SQL Server?
More ...