Pure tech speculation here - and sorry for those who aren't up on database design - but a common pattern for very large tables is to partition the table on specific fields, so part of the table is stored in one file and part in another. If, let's say, the table was partitioned on magic Band...