How use index in Sql Server

Accepted answer

Indexes are two types in sql server cluster and non- cluster. Cluster index might be 0 or 1. In the table, cluster index can’t be more than one. While we can put any number of non- cluster indexes. Generally we use the indexes to improve search results.

+1

Siddhartha Sharma7y ago

Primary key or unique key is considered as a cluster index. And on Search columns we need to implement non-cluster index . We add index on tables. You can take idea from below link https://docs.microsoft.com/en-us/sql/relational-databases/indexes/create-nonclustered-indexes?view=sql-server-2017 Please let me know if you need to discuss in more details .

+1

Chittaranjan Swain7y ago

yes i know, How to implement in application with Example.

0

Jeeva Subburaj7y ago

could you elaborate your question with some more details? indexes are used for better performance on reading the data with less I/O operations.

+1