About types of indexes in SQL server ?

Answers were Sorted based on User's Feedback



About types of indexes in SQL server ?..

Answer / pandian

There are two types of indexs.
1. Cluster Index (Ex. Primary Key)
2. Non Cluster Index(Ex.Unique Key)

Is This Answer Correct ?    9 Yes 3 No

About types of indexes in SQL server ?..

Answer / bala

Filtered Index in case of SQL Server 2008

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL Server Interview Questions

Explain about service Broker functions?

0 Answers  


What is the use of keyword with encryption.

0 Answers  


Is natural join and equi join same?

0 Answers  


Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,


What is tempdb in sql server?

0 Answers  






What are scalar functions?

0 Answers  


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  


Mention the differences between sql server and mysql.

0 Answers  


How do I connect to sql server database?

0 Answers  


What do you understand by physical_only option in dbcc checkdb?

0 Answers  


How many categories of data types used by sql server?

0 Answers  


What is difference between drop truncate and delete?

0 Answers  


Categories