Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2012-05-16 : 00:18:39
|
| We have recently conducted the SQL Infrastructure Systems Report in which it was certified to remove the REINDEX Processing and SEEK the INDEXES induction to the existing indexes to speed up the process.Currently the existing indexes were fine with the ongoing application derivatives for the end-users, however, this is likely to increase the influx of accessing the data to various methods such as Application developing, Report enhancement, Querying etc.In order to conduct such survey what should be done to the exisiting database (Indexes) such that to verify whether any new Indexes required or not, or to modify the existing indexes.Can anyone come across such process / (With the help of tool) like-wise above would be very appreciated.Thanks All. |
|
|
|
|
|
Index Behaviour