This is a dedicated watch page for a single video.
In the process of designing storage for two relational tables within a sizable 10-TB database on Google Cloud, your aim is twofold: firstly, to facilitate horizontally scalable transactions, and secondly, to optimize data for range queries on non-key columns. What approach should you adopt to achieve these objectives effectively?