Question: 1. how can splitting a table improve performance?
Answer: Quote from 1: Partitioning makes large tables or indexes more manageable, because partitioning enables you to manage and access subsets of data quickly and efficiently, while maintaining the integrity of a data collection.