> For Amazon, that means the orders table and the products table containing the products in the orders table need to be physically colocated. Isnt this some wr

> For Amazon, that means the orders table and the products table containing the products in the orders table need to be physically colocated. Isnt this some wrong simplification? Product number can stay the same, but be a different thing over time. Product 12345 can be a book on first January 2023, while a comic book on first March 2023 . The idea is that product versions can change over time. (What is mostly abused by scammers who farm fake reviews and bait and switch products). So probably they have some product history table, or save the product information in the order. Also sharding in big data environment is when your data does not fit into Excel anymore, so you have 20 Acess files (1GB database limit in Access).