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 WITH CHECK OPTION
3 Answers Karur Vysya Bank KVB,
What is view in sql?
Diff. b/w Full Outer Join And Cross Join?
what is difference between primary key and Unique
If there is failure during updation of certain rows, what will be the state?
What is the process of normalization?
Describe in brief system database.
Explain what is “asynchronous” communication in sql server service broker?
What does truncate do?
Differentiate between SQL and ORACLE joins and write their syntax.
how can i lock the column in the table
What is the default server name for sql server?
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)