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
How fixed length strings are truncated and padded?
When a primary key constraint is included in a table, what other constraints does this imply?
Explain how does the report manager work in ssrs?
What authentication modes does sql server support?
What method is used by the Command classes to execute SQL statements that return single values?
What is the difference between ddl,dml and dcl commands?
What are orphan records?
What is auditing in sql server?
What are sub reports and how to create them?
How to view existing indexes on an given table using sp_help?
What is the difference RDBMS and Graph Database?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
Why use “pivot” in sql server?
How to delete all rows with truncate table statement in ms sql server?
What do you understand by a view?