How many types of indexes are there in SQL Server?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between indexing and hashing?
What is the difference between a view and a stored procedure?
How to replace given values with null using nullif()?
What is the rdl file?
What is sql collation?
What is de-normalization in sql database administration? Give examples?
What the different components in replication and what is their use?
how would you store your query in an SSRS report or a Database server?
What is collation?
What is the use of nvl work?
What is difference between drop truncate and delete?
What is Replication?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What are the tool windows in sql server management studio? : sql server management studio
Difference between group by clause and having clause in SQL?