Software job search
.net sql interview questions
  The best place for technical interview questions

 
Home.netSql serverAsp.netC#Vb.netAdo.netAjaxMcpd dumpsWord count tool
You are here >> sql server interview questions  
Question. What are indexes?

Indexes are used in a table for fast retrieval of data while searching. Indexes works in the same way similar to a dictionary where finding a word is much more easier than compared to a normal book.

There are 2 types of indexes in SQL server

Clustered index – only 1 is allowed in a table.

Nonclustered index – SQL 2012 allows up to 999 nonclustered indexes in a table



Previous question Next question
 Rate this answer
     
 28 votes , average 3 out of 5

Back to sql server interview questions
This question has been viewed 7320 times   

Other questions on sql server interview questions




More SQL Server interview questions
SQL Server interview questions

Reader's opinions -

No comments
Loading

 
.net interview questions
Asp.net interview questions
C# interview questions
Vb.net interview questions
Ado.net interview questions
Ajax interview questions
Wcf interview questions
Wpf interview questions
.net threading interview questions
.net remoting and webservices interview questions
.net caching interview questions
.net oops interview questions
Sharepoint interview questions
Jquery interview questions
Silverlight interview questions
Linq interview questions
Wwf interview questions
Java interview questions
Sql server interview questions
Ssis interview questions
Ssrs interview questions
Data warehousing interview questions
Data mining interview questions
Oracle interview questions
Php interview questions
Design patterns interview questions
Uml interview questions
Mcpd dumps
Pmp practice tests

This site is best viewed with Internet Explorer 7.0 or higher, Firefox 2.0 or higher, Chrome at a minimum screen resolution of 1024x768.
A complete solution to interview questions
free matrimonial website      
web hosting plans |  compare vps hosting plans |  Compare dedicated hosting plans |  Compare linux hosting plans |  Compare cloud hosting plans |  Compare windows hosting plans | 
Hosting reviews |  GoDaddy reviews | 
Support Wikipedia