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 |
Differentiate between delete and truncate.
What xml support does the sql server extend?
What are the tool windows in sql server management studio? : sql server management studio
What are the dmvs?
What is history table in sql server?
What is use of except clause? How it differs from not in clause?
How to install sql server 2005 express edition?
How to Rebuild Master database in sql server 2005.
What is difference between primary key and foreign key?
What is the difference between system objects and user objects?
Explain what are commit and rollback in sql?
internal language used in sql server 2000?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)