More metadata columns could mean a bigger catalog and less cache hits. For many types of indexes (ex FieldIndex, KeywordIndex) it is possible to read the original value from the index itself, something like this https://play.pixelblaster.ro/blog/2017/01/08/do-you-really-need-that-metadata-column/
3 Likes