How would you design a database schema for an e-commerce platform, and what indexing strategies would you use to optimize query performance?
