What are some of the database optimizations for multi-tenant applications.

Question

Salesforce’s secret sauce: It queries its databases with “The Multi-Tenant Optimizer" So exactly what could this practice be comprised of?

Answer 1

A whole lot of marketing.

Answer 2

Denormalizing the data so that every row has the "tenant id" in it which reduces the number of necessary joins that have to be done to find the owner of the data. Just a guess.

Answer 3

Patent application is here Broadly, separate stats for each tenant/user.

Answer 4

Here's a link to one of their webinars, where their chief architect talked about their database architecture.