Good article. I have to admit sometimes I cheat and have more than five indexes with one column each when I'm optimizing Rushmore on temporary cursors, but otherwise, this is really good advice.
Keeping it simple, keeps it fast.
Paul H. Tarver Email: paul@tpcqpc.com
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Monday, October 08, 2018 2:24 PM To: profoxtech@leafe.com Subject: [NF] How many indexes do you need?
The message the author presents works across all data environments.
https://www.brentozar.com/archive/2018/10/index-tuning-week-how-many-indexes -are-too-many/