{"id":16209,"date":"2024-04-01T11:25:16","date_gmt":"2024-04-01T18:25:16","guid":{"rendered":"https:\/\/www.pingcap.com\/?post_type=event&#038;p=16209"},"modified":"2024-05-10T08:33:12","modified_gmt":"2024-05-10T15:33:12","slug":"tidb-query-optimization","status":"publish","type":"event","link":"https:\/\/www.pingcap.com\/ko\/event\/tidb-query-optimization\/","title":{"rendered":"Scaling High-Performance Applications with Distributed SQL"},"content":{"rendered":"<p style=\"font-size:22px\"><\/p>\n\n\n\n<p style=\"font-size:22px\">Query optimization is an integral part of any relational database management system. It\u2019s the \u201chow\u201d for processing all SQL requests to the database. With TiDB, the goal is to allow your applications to scale without disruption as you scale your system to heights only possible with distributed SQL architecture.<\/p>\n\n\n\n<p style=\"font-size:22px\">In this webinar, PingCAP Optimizer Architect Terry Purcell utilizes his two decades of expert insights to simplify the challenges behind query optimization. He also reveals how TiDB&#8217;s optimizer is uniquely qualified to keep distributed systems running at massive scale.<\/p>\n\n\n\n<div style=\"height:49px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p style=\"font-size:22px\"><strong>Speaker<\/strong><\/p>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"867\" height=\"867\" src=\"https:\/\/static.pingcap.com\/files\/2024\/03\/25091403\/Terry-Purcell-Profile-Picture_modified.png\" alt=\"\" class=\"wp-image-16210\" style=\"width:225px;height:auto\" srcset=\"https:\/\/static.pingcap.com\/files\/2024\/03\/25091403\/Terry-Purcell-Profile-Picture_modified.png 867w, https:\/\/static.pingcap.com\/files\/2024\/03\/25091403\/Terry-Purcell-Profile-Picture_modified-300x300.png 300w, https:\/\/static.pingcap.com\/files\/2024\/03\/25091403\/Terry-Purcell-Profile-Picture_modified-150x150.png 150w, https:\/\/static.pingcap.com\/files\/2024\/03\/25091403\/Terry-Purcell-Profile-Picture_modified-768x768.png 768w\" sizes=\"auto, (max-width: 867px) 100vw, 867px\" \/><\/figure>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\">\n<div style=\"height:0px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\"><\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\"><\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\"><\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<p style=\"font-size:22px\"><strong>Terry Purcell<\/strong><\/p>\n\n\n\n<p style=\"font-size:22px\">Terry Purcell is an Optimizer Architect at PingCAP, working on the development of the TiDB query optimizer. He has over two decades of experience in query optimization, including 10 years leading one of the most reliable cost-based optimizers in the industry. Terry has contributed to more than 40 US patents, as well as countless webinars, white papers, articles, and conference presentations.<\/p>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Query optimization is an integral part of any relational database management system. It\u2019s the \u201chow\u201d for processing all SQL requests to the database. With TiDB, the goal is to allow your applications to scale without disruption as you scale your system to heights only possible with distributed SQL architecture. In this webinar, PingCAP Optimizer Architect [&hellip;]<\/p>\n","protected":false},"featured_media":16211,"template":"","categories":[],"tags":[],"region":[214,215,216],"location":[207],"class_list":["post-16209","event","type-event","status-publish","has-post-thumbnail","hentry","region-apac","region-emea","region-north-america","location-virtual"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Scaling High-Performance Applications with Distributed SQL | TiDB<\/title>\n<meta name=\"description\" content=\"Explore the insights to simplify the challenges behind query optimization, discover how TiDB&#039;s optimizer is uniquely qualified at scale.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pingcap.com\/ko\/event\/tidb-query-optimization\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Scaling High-Performance Applications with Distributed SQL | TiDB\" \/>\n<meta property=\"og:description\" content=\"Explore the insights to simplify the challenges behind query optimization, discover how TiDB&#039;s optimizer is uniquely qualified at scale.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/event\/tidb-query-optimization\/\" \/>\n<meta property=\"og:site_name\" content=\"TiDB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/pingcap2015\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-10T15:33:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2024\/05\/01185737\/pingcap_twitter_1600x900.png\" \/>\n\t<meta property=\"og:image:width\" content=\"3200\" \/>\n\t<meta property=\"og:image:height\" content=\"1800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/static.pingcap.com\/files\/2024\/05\/01185737\/pingcap_twitter_1600x900.png\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/\",\"url\":\"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/\",\"name\":\"Scaling High-Performance Applications with Distributed SQL | TiDB\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/03\/25104430\/pingcap_feature_1800x600.png\",\"datePublished\":\"2024-04-01T18:25:16+00:00\",\"dateModified\":\"2024-05-10T15:33:12+00:00\",\"description\":\"Explore the insights to simplify the challenges behind query optimization, discover how TiDB's optimizer is uniquely qualified at scale.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2024\/03\/25104430\/pingcap_feature_1800x600.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/03\/25104430\/pingcap_feature_1800x600.png\",\"width\":3600,\"height\":1200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Events\",\"item\":\"https:\/\/www.pingcap.com\/event\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Scaling High-Performance Applications with Distributed SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pingcap.com\/#website\",\"url\":\"https:\/\/www.pingcap.com\/\",\"name\":\"TiDB\",\"description\":\"TiDB | SQL at Scale\",\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pingcap.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pingcap.com\/#organization\",\"name\":\"PingCAP\",\"url\":\"https:\/\/www.pingcap.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"width\":811,\"height\":232,\"caption\":\"PingCAP\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/pingcap2015\",\"https:\/\/x.com\/PingCAP\",\"https:\/\/linkedin.com\/company\/pingcap\",\"https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Scaling High-Performance Applications with Distributed SQL | TiDB","description":"Explore the insights to simplify the challenges behind query optimization, discover how TiDB's optimizer is uniquely qualified at scale.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pingcap.com\/ko\/event\/tidb-query-optimization\/","og_locale":"ko_KR","og_type":"article","og_title":"Scaling High-Performance Applications with Distributed SQL | TiDB","og_description":"Explore the insights to simplify the challenges behind query optimization, discover how TiDB's optimizer is uniquely qualified at scale.","og_url":"https:\/\/www.pingcap.com\/ko\/event\/tidb-query-optimization\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2024-05-10T15:33:12+00:00","og_image":[{"width":3200,"height":1800,"url":"https:\/\/static.pingcap.com\/files\/2024\/05\/01185737\/pingcap_twitter_1600x900.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_image":"https:\/\/static.pingcap.com\/files\/2024\/05\/01185737\/pingcap_twitter_1600x900.png","twitter_site":"@PingCAP","twitter_misc":{"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/","url":"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/","name":"Scaling High-Performance Applications with Distributed SQL | TiDB","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2024\/03\/25104430\/pingcap_feature_1800x600.png","datePublished":"2024-04-01T18:25:16+00:00","dateModified":"2024-05-10T15:33:12+00:00","description":"Explore the insights to simplify the challenges behind query optimization, discover how TiDB's optimizer is uniquely qualified at scale.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2024\/03\/25104430\/pingcap_feature_1800x600.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2024\/03\/25104430\/pingcap_feature_1800x600.png","width":3600,"height":1200},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/event\/tidb-query-optimization\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"Events","item":"https:\/\/www.pingcap.com\/event\/"},{"@type":"ListItem","position":3,"name":"Scaling High-Performance Applications with Distributed SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.pingcap.com\/#website","url":"https:\/\/www.pingcap.com\/","name":"\ud2f0DB","description":"TiDB | SQL at Scale","publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pingcap.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.pingcap.com\/#organization","name":"PingCAP","url":"https:\/\/www.pingcap.com\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/","url":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","width":811,"height":232,"caption":"PingCAP"},"image":{"@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/pingcap2015","https:\/\/x.com\/PingCAP","https:\/\/linkedin.com\/company\/pingcap","https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA"]}]}},"card_markup":"<a class=\"card-resource bg-white\" href=\"https:\/\/www.pingcap.com\/ko\/event\/tidb-query-optimization\/\"><div class=\"card-event__image-container\"><img class=\"card-event__image\" alt=\"pingcap_feature_1800x600\" src=\"https:\/\/static.pingcap.com\/files\/2024\/03\/25104430\/pingcap_feature_1800x600.png\" loading=\"lazy\" width=3600 height=1200 \/><\/div><div class=\"card-event__content-container\"><div class=\"card-resource__content-status\"><div class=\"card-resource__status completed\">Completed<\/div><div class=\"card-resource__webinar\"><i><\/i>On-Demand<\/div><\/div><h5 class=\"card-resource__title\">Scaling High-Performance Applications with Distributed SQL<\/h5><p class=\"card-resource__date\"><i class=\"icon-calendar-check\"><\/i>Jan 1 12:00 am - 12:00 am PDT<\/p><p class=\"card-resource__location\"><i class=\"icon-map-pin\"><\/i>Virtual<\/p><\/div><\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/event\/16209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/event"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/event"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/16211"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=16209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=16209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=16209"},{"taxonomy":"region","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/region?post=16209"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/location?post=16209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}