My day job at a smallish company has five different applications with tables more than 100M rows. This is not uncommon at all, especially for apps that need to

My day job at a smallish company has five different applications with tables more than 100M rows. This is not uncommon at all, especially for apps that need to retain audit history tables. Assuming you can’t toss history for business or compliance reasons, tables with 100M rows become commmon when an app has been in service for more than a few years. Even in SMBs.