How Lightning Platform Query Optimizer works for LDV

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...

[@apexhours]

Check blog post for PPT and Code www.apexhours.com/how-salesforce-query-optimizer-works-for-ldv/

[@maqx81]

Jitendra, you are a rock star, thanks for explaining and clarifying these concept!!!

[@apexhours]

we are glad you liked it. Please share with others and subscribe

[@arijitnagchowdhury3740]

VERY Nice explanation Jitendra. !!.. One quick Q: Can we do DML inside Skinny table

[@apexhours]

You need to raise request in Salesforce to enable the Skinny table

[@rajkumargaikwad5031]

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.

[@sharathposa]

Presenter Uses ambiguous words. It would be really helpful if you could make your point crisply..

[@apexhours]

Glad you liked it

[@sumansaha2386]

Could you please elaborate Index table structure?

[@arijitnagchowdhury3740]

29:14 sec - (AND Operator), "NOT" returning more than 20%