(author)

If you're already using a relational database you should almost certainly set up indexes on your table ids and foreign keys. But that's pretty different from the examples in the post!

I'm not anti-index, I'm anti-"if you ever have a full table scan in production you're doing it wrong".