Your Cloud Spanner database stores inventory data for a global e-commerce platform, with products organized by category and subcategory in separate tables linked by foreign keys. Frequent queries on these tables are causing performance bottlenecks. How can you optimize the database design for better query performance while following Google’s best practices?