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


Please Help Members By Posting Answers For Below Questions

What is an indice?

572


How to find the login name linked to a given user name?

528


How to defragment table indexes?

546


How to list all stored procedures in the current database using ms sql server?

632


What is statement level trigger?

537






How will you optimize a stored procedure optimization?

509


What is the order in which the sql query is executed?

521


How to update muliple row in single query?

605


How many types of functions are there in sql server?

457


List the different types of collation sensitivities in sql server?

522


How to check if a table is being used in sql server?

513


What is meant by dirty read?

554


What is sql server management studio? : sql server management studio

578


what is a traditional network library for sql servers? : Sql server database administration

462


What is wide table?

534