I think he intended to say that Rails does not (cannot) automatically add indexes to your database, which is true and makes more sense in the context.
As mickeyben says above, choosing indexes is a compromise - you sacrifice performance in one area for performance in another. Only you can make the right decision there, because only you can begin to know how the app will be used in production.