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 http://www.apexhours.com/how-salesforce-query-optimizer-works-for-ldv/