Imagine you have a huge vendors table in an e‑commerce system, and thousands of orders are created every second.

Every time a new order comes in, the system needs to:

check if the vendor exists

check if the vendor is active

check if the product belongs to that vendor