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 |
Advantages and disadvantages of stored procedures.
What is deadlock and how to avoid the deadlocks.
Why I am getting this error when renaming a database in ms sql server?
What are out-of-range errors with date and time literals?
What stored by the msdb? : sql server database administration
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3
Describe triggers features and limitations?
What are the steps to insert a table?
What is difference between after and before?
What is cube dimension? : sql server analysis services, ssas
Why I have to use stored procedures?
What is blocking?
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)