{"id":6800,"date":"2019-03-05T21:12:21","date_gmt":"2019-03-06T02:12:21","guid":{"rendered":"https:\/\/www.jitendrazaa.com\/blog\/?p=6800"},"modified":"2019-03-05T21:12:28","modified_gmt":"2019-03-06T02:12:28","slug":"video-large-data-volume-how-lightning-platform-query-optimizer-works","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/video-large-data-volume-how-lightning-platform-query-optimizer-works\/","title":{"rendered":"Video &#8211; Large Data Volume &#8211; How Lightning Platform Query Optimizer Works"},"content":{"rendered":"\n<p>Last year I presented how Query Optimizer works in Kitchner developer group. Found myself coming back to slide multiple times, so thought its good idea to post all information in this post.<\/p>\n\n\n\n<iframe loading=\"lazy\" src=\"\/\/www.slideshare.net\/slideshow\/embed_code\/key\/6JYBeh9nPq7tPM\" width=\"595\" height=\"485\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" style=\"border:1px solid #CCC; border-width:1px; margin-bottom:5px; max-width: 100%;\" allowfullscreen> <\/iframe>  \n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How Lightning Platform Query Optimizer works for LDV\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/FtfZV5uf9fg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Best Practices of handling Large Data Volume (LDV) in Salesforce<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"jz_research_post":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9],"tags":[249,248,212],"class_list":["post-6800","post","type-post","status-publish","format-standard","hentry","category-salesforce","tag-large-data-volumes","tag-ldv","tag-video-tutorial"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":3855,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/large-data-volumes-ldv-in-salesforce\/","url_meta":{"origin":6800,"position":0},"title":"Large Data Volumes (LDV) in Salesforce | FAQs | Interview Questions","author":"Jitendra","date":"April 18, 2014","format":false,"excerpt":"You would like to go through this useful cheat sheet for \"Query and Search\" optimization, few of this is discussed in this post as FAQ. 171 : How Standard Fields and Custom Fields related information is saved inside Salesforce Database? Is every Standard and Custom Object is created as a\u2026","rel":"","context":"In &quot;Configuration&quot;","block_context":{"text":"Configuration","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/configuration\/"},"img":{"alt_text":"Skinny Table","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2014\/04\/Skinny-Table.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":31927,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/salesforce-scale-center-complete-guide-performance\/","url_meta":{"origin":6800,"position":1},"title":"Salesforce Scale Center Complete Guide: Performance Monitoring &#038; Optimization | March 2026","author":"Jitendra","date":"March 12, 2026","format":false,"excerpt":"Master Salesforce Scale Center for performance monitoring and optimization. Learn setup, ApexGuru integration, concurrent Apex analysis, and best practices for enterprise scalability with 9 analysis report types.","rel":"","context":"In &quot;Apex&quot;","block_context":{"text":"Apex","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/apex\/"},"img":{"alt_text":"Salesforce Scale Center Infographic - Free self-serve performance monitoring platform with 9 report types, 30-day data retention, and 10-12 minute latency for Enterprise, Unlimited, and Professional Edition orgs","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2026\/03\/Salesforce-Scale-Center-Complete-Guide-infographic.png?fit=1200%2C1148&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2026\/03\/Salesforce-Scale-Center-Complete-Guide-infographic.png?fit=1200%2C1148&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2026\/03\/Salesforce-Scale-Center-Complete-Guide-infographic.png?fit=1200%2C1148&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2026\/03\/Salesforce-Scale-Center-Complete-Guide-infographic.png?fit=1200%2C1148&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2026\/03\/Salesforce-Scale-Center-Complete-Guide-infographic.png?fit=1200%2C1148&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":26188,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/salesforce-cpq-what-the-future-holds-when-rlm-is-on-horizon\/","url_meta":{"origin":6800,"position":2},"title":"Salesforce CPQ &#8211; What The Future Holds When RLM is on Horizon","author":"Jitendra","date":"December 28, 2024","format":false,"excerpt":"Salesforce CPQ is a solution for managing complex product configurations and pricing, integrating seamlessly with Salesforce environments. Key features include Product Bundles, Configuration Attributes, and Multi-Dimensional Quoting (MDQ). With the advent of Revenue Lifecycle Management (RLM), CPQ's functionality is evolving to address subscription models and enhance revenue management efficiency.","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Salesforce CPQ","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2024\/12\/Salesforce-CPQ.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2024\/12\/Salesforce-CPQ.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2024\/12\/Salesforce-CPQ.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2024\/12\/Salesforce-CPQ.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2024\/12\/Salesforce-CPQ.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":6244,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/a-tale-of-governor-limits-and-solutions-in-salesforce\/","url_meta":{"origin":6800,"position":3},"title":"A Tale of Governor Limits and Solutions in Salesforce","author":"Jitendra","date":"November 21, 2017","format":false,"excerpt":"Thrilling story of Salesforce Technical Architect on a quest to solve application problems and avoid governor limit errors","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"A Tale of Governor Limits and Solutions in Salesforce","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/09\/A-Tale-of-Governor-Limits-and-Solutions-in-Salesforce.jpg?fit=900%2C417&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/09\/A-Tale-of-Governor-Limits-and-Solutions-in-Salesforce.jpg?fit=900%2C417&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/09\/A-Tale-of-Governor-Limits-and-Solutions-in-Salesforce.jpg?fit=900%2C417&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/09\/A-Tale-of-Governor-Limits-and-Solutions-in-Salesforce.jpg?fit=900%2C417&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":5515,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/batch-apex-first-error-apex-cpu-time-limit-exceeded\/","url_meta":{"origin":6800,"position":4},"title":"Batch Apex &#8211; First error: Apex CPU time limit exceeded","author":"Jitendra","date":"June 1, 2016","format":false,"excerpt":"Lessons learned while fixing error in Batch Apex , First error: Apex CPU time limit exceeded","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4709,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/using-curl-with-salesforce-rest-api\/","url_meta":{"origin":6800,"position":5},"title":"using cURL with Salesforce Rest API","author":"Jitendra","date":"July 16, 2015","format":false,"excerpt":"Workbench is one of widely used tool in Salesforce when it comes to exploring REST API of Salesforce. However\u00a0I wanted to export REST API response\u00a0in Binary format and therefore used cURL. cURL is open source command line library mostly used to test\u00a0http request. It can be downloaded from here\u00a0and official\u2026","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Salesforce visualforce security check using cURL","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/07\/Salesforce-visualforce-security-check-using-cURL.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/07\/Salesforce-visualforce-security-check-using-cURL.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/07\/Salesforce-visualforce-security-check-using-cURL.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/07\/Salesforce-visualforce-security-check-using-cURL.png?resize=700%2C400&ssl=1 2x"},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/6800","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/comments?post=6800"}],"version-history":[{"count":1,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/6800\/revisions"}],"predecessor-version":[{"id":6801,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/6800\/revisions\/6801"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=6800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=6800"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=6800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}