How to assert that your SQL does not do full table scans

Hm - it looks like HN pulled the canonical link? I mirrored it on my home page for that reason;

https://5f5.org/mirror/HowToAssertThatYourSQLDoesNotDoFullTa...