How many types of indexes are there in SQL Server?
Answers were Sorted based on User's Feedback
Answer / abcd
9 indexes:
1. Clustered,
2. Non-clustered,
3. Unique,
4. Index with included columns,
5. Indexed views,
6. Full text,
7. Spatial,
8. Filtered &
9. XML
Is This Answer Correct ? | 9 Yes | 4 No |
Answer / chandra bhan singh
Three Type of indexes in sql
1.Clustered
2.Non-clustered
2.Primary XML
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / b.hari kumar reddy
mainly five type of indexes in sql
1.simple index
2.composite index
3.unique index
4.Clustered index
5.Non-clustered index
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mohd zubair khan
Three type of indexes in sql
1.Clustered
2.Non-clustered
3.Unique
Is This Answer Correct ? | 6 Yes | 7 No |
Answer / rohti nanda
Three type of indexes in sql
1.Clustered
2.Non-clustered
3.Unique
Is This Answer Correct ? | 2 Yes | 3 No |
What is data compression?
hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What is the difference between executequery () and executeupdate ()?
Can foreign key be duplicate?
Explain logical operators in sql server?
How to recompile stored procedure at run time?
What happens to a trigger with multiple affected rows?
What is referential integrity and how is it achieved?
Explain the functionalities that views support?
Does transparent data encryption provide encryption when transmitting data across the network?
What are magic tables in sql server?