MOFAKH
.
COM
Profile
Topics
Recent
25 notes
SQL — notes
+
Topics
C#
5
.NET
4
Docker
4
SQL
4
Networking
4
System design
4
SQL — notes
How the optimizer picks an index
Jul 8, 2026 · 8 min
Reading an execution plan end to end
outline
Isolation levels and what each one actually prevents
outline
Multi-tenant row filtering without leaking data
outline
← Back to profile
SQL
Multi-tenant row filtering without leaking data
unwritten
—
Outline
Note to self
Not written yet. This is the outline I am working from — it will be filled in as I go through the topic.
Shared schema with TenantId vs schema-per-tenant vs database-per-tenant
EF Core global query filters and how they get bypassed
Composite indexes that always lead with TenantId
Testing the leak: what a missing filter looks like in a query plan
Previous
Isolation levels and what each one actually prevents
Next
End of this topic