One index. Because SQL is not going to use three different structures and then have to patch them together unless it really has no other choice. It can do...
I think the criticism is less "taking a blowtorch to his backside" and more commenting about how, for an article that clearly states its intended audience is "the junior database...