Hacker News Reader

>Even simple stuff, such as SELECT COUNT(*) edit seems like my old performance book was outdated or wrong :(

SELECT COUNT(*) should be the one which is resolved by index/metadata

Nope. Not even close.