How many types of indexes are there in SQL Server?
Answer Posted / 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 |
Post New Answer View All Answers
What are the differences between local and global temporary tables?
Explain the properties of the relational tables?
What is sql server locking?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
Explain features and concepts of analysis services?
Please differentiate between a local and a global temporary table?
Explain transaction server distributed transaction?
How to create a simple user defined function in ms sql server?
Describe in brief authentication modes in sql server.
What is a non-clustered index?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
Describe different Processing Modes offered by SSRS?
How to add more data to the testing table in ms sql server?
Are resultset updatable?
What is a file group?