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

How to generate create function script on an existing function?

0 Answers  


How can we Use Linked Server? Uses of Linked server

1 Answers   IBM,


How many primary keys are possible in a table?

0 Answers  


Write a query for primary key constraint with identity key word?

0 Answers   MindCracker,


What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,






You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  


Why truncate is ddl command?

0 Answers  


what is the difference between sql query and google query?

10 Answers   TCS,


find the 3rd max salary

10 Answers  


After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  


What are the advantages of using third-party tools?

0 Answers  


What do you understand by sql server agent?

0 Answers  


Categories