An optimized approach to indexing is important if you are keen to keep the performance of an SQL Server instance at its best and, in turn ,deliver a consistent experience for end users of any software solution that relies on it.

This is an easy thing to say but harder to achieve in practice unless you have the right strategies and solutions at your disposal as an administrator.