How Lightning Platform Query Optimizer works for LDV
HTML-код
- Опубликовано: 11 сен 2024
- How Lightning Platform Query Optimizer works for LDV
Multi Tenant Architecture, Skinny Table, Indexing Table & Index Statistics, Upper Limit on, Standard & Custom Indexed Field, Limit on AND , OR and LIKE operator, SystemModstamp vs LastModifiedDate
, Query Plan Tool
Blog post www.apexhours.c...
Check blog post for PPT and Code www.apexhours.com/how-salesforce-query-optimizer-works-for-ldv/
Jitendra, you are a rock star, thanks for explaining and clarifying these concept!!!
we are glad you liked it. Please share with others and subscribe
VERY Nice explanation Jitendra. !!.. One quick Q: Can we do DML inside Skinny table
You need to raise request in Salesforce to enable the Skinny table
As per the instructor , provided SystemModstamp information is incorrect. I tried this in workbench and checked. I created one record with past date and tried to query the same using SystemModstamp > , it didn't return that record.
Table as follows -
Id CreatedDate LastModifiedDate SystemModstamp
a022v00001OeQy7 1992-06-20T07:47:32.000Z 1992-06-20T07:47:32.000Z 2019-11-16T07:10:47.000Z
Query is : SELECT id,Name, LastmodifiedDate , SystemModstamp FROM Ride_Info__c WHERE LastmodifiedDate > 2019-11-16T07:10:00.000Z
Please check that in Datetime filter condition, I changed only second component from Datetime (2019-11-16T07:10:47.000Z to 2019-11-16T07:10:00.000Z)
Ride_Info__c is custom object in my personal dev org.
Presenter Uses ambiguous words. It would be really helpful if you could make your point crisply..
Glad you liked it
Could you please elaborate Index table structure?
29:14 sec - (AND Operator), "NOT" returning more than 20%