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 |
Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....
What is the difference between a local and a global variable?
How do I list the available tables in a database I'm querying?
what is the output for this query select * from employee where 1=1;
How extra digits are handled with numeric data type literals?
How to automatically create a log when an exception is being received into SQL Server?
How to remove duplicate rows from table?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What are the lambda triggers?
What is a heap?
What are the magic tables in SQL Server 2000?
7 Answers Infogain, Merrill Lynch,
Define self join in sql server joins?
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)