SF doesn’t have tables. It is not a relational database. It is slow because it is an enterprise application.
The link details the steps that are triggered every time a record is updated.
https://www.salesforceben.com/learn-salesforce-order-of-exec...
A crucial aspect of the relational database is that the tables have columns which refer to another table (e.g. AccountId) and this what they call “lookup relationships” or “master-detail relationships” in Salesforce.
Also, I recently learned that SQL has triggers too in case you want the same procedure to take place after an INSERT, UPDATE, etc.
JOINS do not exist in Salesforce. Instead you have to create bridge tables. Even then you can only traverse a max of three objects at a time.
Please do not try to use Salesforce as a general database, you are only putting yourself in a world of hurt.
