We can find out the missing indexes and as well as the statistics by using DTA(Data Tuning Adviser) in sql 2k8...
The other way to find out the missing index details is from using the syntax below:-
select * from sys.dm_db_missing_index_details
Note:- Please keep in mind that too many indexes will affect the performance of the database.
The other way to find out the missing index details is from using the syntax below:-
select * from sys.dm_db_missing_index_details
Note:- Please keep in mind that too many indexes will affect the performance of the database.
No comments:
Post a Comment