![\"\"](\"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/03\/index2.gif\")
<\/p>\nHi,<\/p>\n
The use of Index in the SQL Server database occurs in environments that require the most performance, speed, and memory savings.<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n\n
In a table with millions or billions of records, we can use a Index\u00a0 to read fewer records and search less to find related record.<\/p>\n
Accurately created Index, millions of records within the database we have searched within a very short time to bring the record of the caller’s convenience, while at the same time less read the record by reaching the target record, we use the operating system resources effectively.<\/p>\n
You should create index for mostly read only queries on a table.\u00a0 If Delete,update operations are more than read only queries, you should not create index that table.<\/p>\n
You can look at the missing index recommendation of SQL Server with following script. You can create missing index but you should monitor these index, If they are not useful, you should drop them.<\/p>\n
<\/p>\n
SELECT MID.[statement] AS ObjectName\r\n,MID.equality_columns AS EqualityColumns\r\n,MID.inequality_columns AS InequalityColms\r\n,MID.included_columns AS IncludedColumns\r\n,MIGS.last_user_seek AS LastUserSeek\r\n,MIGS.avg_total_user_cost \r\n* MIGS.avg_user_impact \r\n* (MIGS.user_seeks + MIGS.user_scans) AS Impact\r\n,N'CREATE NONCLUSTERED INDEX <TYPE_Index_Name> ' + \r\nN'ON ' + MID.[statement] + \r\nN' (' + MID.equality_columns \r\n+ ISNULL(', ' + MID.inequality_columns, N'') +\r\nN') ' + ISNULL(N'INCLUDE (' + MID.included_columns + N');', ';')\r\nAS CreateStatement\r\nFROM sys.dm_db_missing_index_group_stats AS MIGS\r\nINNER JOIN sys.dm_db_missing_index_groups AS MIG\r\nON MIGS.group_handle = MIG.index_group_handle\r\nINNER JOIN sys.dm_db_missing_index_details AS MID\r\nON MIG.index_handle = MID.index_handle\r\nWHERE database_id = DB_ID()\r\nAND MIGS.last_user_seek >= DATEDIFF(month, GetDate(), -1)\r\nORDER BY Impact DESC;\r\n\r\n<\/pre>\n <\/p>\n
Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.<\/span><\/h4>\n