Speaker
Stanislaw Zań
(Polish-Japanese Academy of Information Technology)
Description
Study on how in the multitenant cloud architecture of the Salesforce platform, different field configurations available to administrators impact database index usage, query costs, and data manipulation language operations. Results show that while "External ID" and "Unique" settings consistently create indexes with varying performance effects, the "Required" flag unexpectedly affects query costs in a meaningful manner. Results highlight the need for case-by-case tuning using the Salesforce Query Planner.
database indexes, Salesforce, multi-tenant architecture, database tuning, CRM
Author
Stanislaw Zań
(Polish-Japanese Academy of Information Technology)
