RE: [NF] How many indexes do you need?

At 09:43 2018-10-09, "Paul H. Tarver" paul@tpcqpc.com wrote:

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.

This is stupid advice. An arbitrary number of indexes is not correct. Instead, determine how many indexes are required and create that many.

Keeping it simple, keeps it fast.

But it might not meet the needs of the users.

[snip]

Sincerely,

Gene Wirchenko