Answer Posted / Deepak Kumar Pathak
In SQL Server, there are several types of indexes: Clustered Indexes (which determine the physical order of data in a table), Non-Clustered Indexes (which have a separate structure that stores the indexed columns and a pointer to the actual data), Composite Indexes (which are created using multiple columns), Primary Key Indexes (which are a type of clustered index used to uniquely identify each row), Unique Indexes (which ensure that no two rows have duplicate values for the specified columns), and Full-Text Indexes (which are used for text search queries).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a view in sql?
How to connect php with different port numbers?
What is in place upgrade in sql server?
What is sql or structured query language?
What is acid mean in sql server?
List out the different types of locks available in sql server?
How to convert character strings into numeric values?
How to remove duplicate rows from table except one?
Where can you add custom error messages to sql server?
What is an indexed view?
Why use identity in sql server?
Disadvantages of the indexes?
How can we solve concurrency problems?
How efficient you are in oracle and SQL server?
Can you index views?
