CODEWITHSUNDEEP
sql-server
Bala vinoth
Bala vinoth

Reputation: 13

Uses of Index in SQL server

I'm new to Index Constraints in SQL Server... Can anybody instruct me to clear my doubt... I've created an Index named EmpName by using the EName as ColumnName.

Create index EmpName on Users_Info (EName)

How can I check the use of created Index in the SQL????

And I wanna know the difference of search results in the presence & absence of Index...

Thanks

Upvotes: 1

Views: 145

Answers (3)

PaulMJax
PaulMJax

Reputation: 216

Take a look at SQL DMV (Dynamic Management Views) as they provide helpful performance information. sys.dm_db_index_usage_stats provides usage on indexes organized by database, object (id of the table) and index_id (id of the index).

Upvotes: 0

JammoD
JammoD

Reputation: 429

Take a look at SQL Execution Plans - These will help you when analysing the performance of your tables and indexes.

Upvotes: 1

MiroslavStojakovic
MiroslavStojakovic

Reputation: 167

There are few things that can be important when we speak about indexes and performance:

1.There are dozen (about 10) of index types. The Most commonly usage have clustered and no-clustered indexes. Clustered indexes are indexes that ordering rows in some table and no-clustered indexes make additional tables that refers to main table. 2.Because of that no-clustered indexes improve performance during execution of select statement but keep in mind that no-clustered indexes slows down update, insert and delete operations.

Upvotes: 0

Related Questions