Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What are the types of indexes available with SQL Server?

Answers were Sorted based on User's Feedback



What are the types of indexes available with SQL Server?..

Answer / guest

There are basically two types of indexes that we use with
the SQL Server. Clustered and the Non-Clustered.

Is This Answer Correct ?    12 Yes 1 No

What are the types of indexes available with SQL Server?..

Answer / nagabhushan

Indexes are of two types,Clustered Index and non Clustered
Index,when you create Clustee index on tables all the rows
in the tables are stored in the order of the clustered
Index key,So there will one cluster index in the table.Non
Clustered Index have there own storage seperate from the
table data storage.Non Clustered Index is stored in the
form of B-trees.

Is This Answer Correct ?    8 Yes 1 No

Post New Answer

More SQL Server Interview Questions

When should you use an instead of trigger?

0 Answers  


from the table display the 2nd highest salary? and also the least 2nd salay?

8 Answers  


Which system tables contain information on privileges granted and privileges obtained

1 Answers  


What is the difference between upgrade and migration in sql server?

0 Answers  


Explain system views?

0 Answers  






How to link up the text file to a Database table?

2 Answers   Allianz,


What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,


After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,


How many types of dimensions are there and what are they? : sql server analysis services, ssas

0 Answers  


What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  


How to create a view with data from multiple tables?

0 Answers  


Can we write trigger for view?

0 Answers  






Categories