The answer seems to be Yes, if you’re dealing with systems with a large number of stores or categories.
Are Flat Tables Still a Thing in Magento 2?astorm
Frustrated by Magento? Then you’ll love Commerce Bug, the must have debugging extension for anyone using Magento. Whether you’re just starting out or you’re a seasoned pro, Commerce Bug will save you and your team hours everyday. Grab a copy and start working with Magento instead of against it.
Updated for Magento 2! No Frills Magento Layout is the only Magento front end book you'll ever need. Get your copy today!