{"id":28898,"date":"2018-10-29T08:43:26","date_gmt":"2018-10-29T06:43:26","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=28898"},"modified":"2018-10-29T08:45:04","modified_gmt":"2018-10-29T06:45:04","slug":"soar-sql-optimizer-and-rewriter","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/","title":{"rendered":"SOAR &#8211; SQL Optimizer And Rewriter"},"content":{"rendered":"<!-- google_ad_section_start -->\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/soar-1.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"28901\" data-permalink=\"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/soar-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/soar-1.png?fit=644%2C268&amp;ssl=1\" data-orig-size=\"644,268\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"soar\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/soar-1.png?fit=644%2C268&amp;ssl=1\" class=\"aligncenter size-medium wp-image-28901\" src=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/soar-1-500x208.png?resize=500%2C208&#038;ssl=1\" alt=\"\" width=\"500\" height=\"208\" srcset=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/soar-1.png?resize=500%2C208&amp;ssl=1 500w, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/soar-1.png?w=644&amp;ssl=1 644w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/github.com\/XiaoMi\/soar\">SOAR<\/a> is an SQL Optimizer and Rewriter.\u00a0 It can help analyse, optimize, and rewrite SQL queries.\u00a0 Don&#8217;t get offset by the Chinese documentation as default &#8211; there is <a href=\"https:\/\/github.com\/XiaoMi\/soar\/blob\/master\/README_EN.md\">an English translation<\/a>.<\/p>\n<p>Here are some of the features:<\/p>\n<ul>\n<li>Cross-platform support, such as Linux, Mac, and Windows<\/li>\n<li>Support Heuristic Rules Suggestion<\/li>\n<li>Support Complicate SQL Indexing Optimize<\/li>\n<li>Support EXPLAIN analyze for query plan<\/li>\n<li>Support SQL fingerprint, compress and built-in pretty print<\/li>\n<li>Support merge multi ALTER query into one SQL<\/li>\n<li>Support self-config rewrite rules from SQL Rewrite<\/li>\n<li>Suggestions were written in Chinese. But SOAR also gives many tools, which can be used without understanding Chinese.<\/li>\n<\/ul>\n<p>And if you are familiar with the other tools that provide similar functionality, here&#8217;s how SOAR compares to them:<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/comparison.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"28900\" data-permalink=\"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/comparison\/\" data-orig-file=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/comparison.png?fit=890%2C408&amp;ssl=1\" data-orig-size=\"890,408\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"comparison\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/comparison.png?fit=660%2C303&amp;ssl=1\" class=\"aligncenter size-medium wp-image-28900\" src=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/comparison-500x229.png?resize=500%2C229&#038;ssl=1\" alt=\"\" width=\"500\" height=\"229\" srcset=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/comparison.png?resize=500%2C229&amp;ssl=1 500w, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/comparison.png?resize=768%2C352&amp;ssl=1 768w, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/comparison.png?w=890&amp;ssl=1 890w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<!-- google_ad_section_end -->\n","protected":false},"excerpt":{"rendered":"<!-- google_ad_section_start -->\n<p>&nbsp; SOAR is an SQL Optimizer and Rewriter.\u00a0 It can help analyse, optimize, and rewrite SQL queries.\u00a0 Don&#8217;t get offset by the Chinese documentation as default &#8211; there is an English translation. Here are some of the features: Cross-platform support, such as Linux, Mac, and Windows Support Heuristic Rules Suggestion Support Complicate SQL Indexing Optimize &hellip; <a href=\"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">SOAR &#8211; SQL Optimizer And Rewriter<\/span><\/a><\/p>\n<!-- google_ad_section_end -->\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"SOAR - SQL Optimizer And Rewriter #WebDev #databases #SQL #optimization #performance","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false,"_links_to":"","_links_to_target":""},"categories":[1,18,133,62,1334],"tags":[1559,246,1057,1330],"keyring_services":[],"class_list":["post-28898","post","type-post","status-publish","format-standard","hentry","category-general","category-programming","category-sysadmin","category-technology","category-web-work","tag-databases","tag-optimization","tag-performance","tag-web-development"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"SOAR is an SQL Optimizer and Rewriter. It can help analyse, optimize, and rewrite SQL queries. Don&#039;t get offset by the Chinese documentation as default - there is an English translation. Here are some of the features: Cross-platform support, such as Linux, Mac, and Windows Support Heuristic Rules Suggestion Support Complicate SQL Indexing Optimize\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Leonid Mamchenkov\"\/>\n\t<meta name=\"google-site-verification\" content=\"VHvdD0_usx1_4DzKy_QCVcICVgX2EgA2ybELT-wl7kQ\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Leonid Mamchenkov - Life, universe, and everything else\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"SOAR \u2013 SQL Optimizer And Rewriter - Leonid Mamchenkov\" \/>\n\t\t<meta property=\"og:description\" content=\"SOAR is an SQL Optimizer and Rewriter. It can help analyse, optimize, and rewrite SQL queries. Don&#039;t get offset by the Chinese documentation as default - there is an English translation. Here are some of the features: Cross-platform support, such as Linux, Mac, and Windows Support Heuristic Rules Suggestion Support Complicate SQL Indexing Optimize\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2018-10-29T06:43:26+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2018-10-29T06:45:04+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/MamchenkovBlog\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@mamchenkov\" \/>\n\t\t<meta name=\"twitter:title\" content=\"SOAR \u2013 SQL Optimizer And Rewriter - Leonid Mamchenkov\" \/>\n\t\t<meta name=\"twitter:description\" content=\"SOAR is an SQL Optimizer and Rewriter. It can help analyse, optimize, and rewrite SQL queries. Don&#039;t get offset by the Chinese documentation as default - there is an English translation. Here are some of the features: Cross-platform support, such as Linux, Mac, and Windows Support Heuristic Rules Suggestion Support Complicate SQL Indexing Optimize\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@mamchenkov\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/10\\\/29\\\/soar-sql-optimizer-and-rewriter\\\/#blogposting\",\"name\":\"SOAR \\u2013 SQL Optimizer And Rewriter - Leonid Mamchenkov\",\"headline\":\"SOAR &#8211; SQL Optimizer And Rewriter\",\"author\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/soar-1-500x208.png\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/10\\\/29\\\/soar-sql-optimizer-and-rewriter\\\/#articleImage\"},\"datePublished\":\"2018-10-29T08:43:26+02:00\",\"dateModified\":\"2018-10-29T08:45:04+02:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/10\\\/29\\\/soar-sql-optimizer-and-rewriter\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/10\\\/29\\\/soar-sql-optimizer-and-rewriter\\\/#webpage\"},\"articleSection\":\"All, Programming, Sysadmin, Technology, Web work, databases, optimization, performance, web development\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/10\\\/29\\\/soar-sql-optimizer-and-rewriter\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/#listItem\",\"name\":\"Technology\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/#listItem\",\"position\":2,\"name\":\"Technology\",\"item\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/programming\\\/#listItem\",\"name\":\"Programming\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/programming\\\/#listItem\",\"position\":3,\"name\":\"Programming\",\"item\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/programming\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/10\\\/29\\\/soar-sql-optimizer-and-rewriter\\\/#listItem\",\"name\":\"SOAR &#8211; SQL Optimizer And Rewriter\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/#listItem\",\"name\":\"Technology\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/10\\\/29\\\/soar-sql-optimizer-and-rewriter\\\/#listItem\",\"position\":4,\"name\":\"SOAR &#8211; SQL Optimizer And Rewriter\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/programming\\\/#listItem\",\"name\":\"Programming\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#person\",\"name\":\"Leonid Mamchenkov\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/10\\\/29\\\/soar-sql-optimizer-and-rewriter\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3cf6df002a284d78fb6e9d8222ca4d102e0832035ed6bc8447008bd234e131a4?s=96&d=identicon&r=g\",\"width\":96,\"height\":96,\"caption\":\"Leonid Mamchenkov\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/#author\",\"url\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/\",\"name\":\"Leonid Mamchenkov\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/10\\\/29\\\/soar-sql-optimizer-and-rewriter\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3cf6df002a284d78fb6e9d8222ca4d102e0832035ed6bc8447008bd234e131a4?s=96&d=identicon&r=g\",\"width\":96,\"height\":96,\"caption\":\"Leonid Mamchenkov\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/10\\\/29\\\/soar-sql-optimizer-and-rewriter\\\/#webpage\",\"url\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/10\\\/29\\\/soar-sql-optimizer-and-rewriter\\\/\",\"name\":\"SOAR \\u2013 SQL Optimizer And Rewriter - Leonid Mamchenkov\",\"description\":\"SOAR is an SQL Optimizer and Rewriter. It can help analyse, optimize, and rewrite SQL queries. Don't get offset by the Chinese documentation as default - there is an English translation. Here are some of the features: Cross-platform support, such as Linux, Mac, and Windows Support Heuristic Rules Suggestion Support Complicate SQL Indexing Optimize\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/10\\\/29\\\/soar-sql-optimizer-and-rewriter\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/#author\"},\"datePublished\":\"2018-10-29T08:43:26+02:00\",\"dateModified\":\"2018-10-29T08:45:04+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/\",\"name\":\"Blog of Leonid Mamchenkov\",\"description\":\"Life, universe, and everything else\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"SOAR \u2013 SQL Optimizer And Rewriter - Leonid Mamchenkov","description":"SOAR is an SQL Optimizer and Rewriter. It can help analyse, optimize, and rewrite SQL queries. Don't get offset by the Chinese documentation as default - there is an English translation. Here are some of the features: Cross-platform support, such as Linux, Mac, and Windows Support Heuristic Rules Suggestion Support Complicate SQL Indexing Optimize","canonical_url":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"VHvdD0_usx1_4DzKy_QCVcICVgX2EgA2ybELT-wl7kQ","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/#blogposting","name":"SOAR \u2013 SQL Optimizer And Rewriter - Leonid Mamchenkov","headline":"SOAR &#8211; SQL Optimizer And Rewriter","author":{"@id":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/#author"},"publisher":{"@id":"https:\/\/mamchenkov.net\/wordpress\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/soar-1-500x208.png","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/#articleImage"},"datePublished":"2018-10-29T08:43:26+02:00","dateModified":"2018-10-29T08:45:04+02:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/#webpage"},"isPartOf":{"@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/#webpage"},"articleSection":"All, Programming, Sysadmin, Technology, Web work, databases, optimization, performance, web development"},{"@type":"BreadcrumbList","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress#listItem","position":1,"name":"Home","item":"https:\/\/mamchenkov.net\/wordpress","nextItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/#listItem","name":"Technology"}},{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/#listItem","position":2,"name":"Technology","item":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/","nextItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/programming\/#listItem","name":"Programming"},"previousItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/programming\/#listItem","position":3,"name":"Programming","item":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/programming\/","nextItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/#listItem","name":"SOAR &#8211; SQL Optimizer And Rewriter"},"previousItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/#listItem","name":"Technology"}},{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/#listItem","position":4,"name":"SOAR &#8211; SQL Optimizer And Rewriter","previousItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/programming\/#listItem","name":"Programming"}}]},{"@type":"Person","@id":"https:\/\/mamchenkov.net\/wordpress\/#person","name":"Leonid Mamchenkov","image":{"@type":"ImageObject","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/3cf6df002a284d78fb6e9d8222ca4d102e0832035ed6bc8447008bd234e131a4?s=96&d=identicon&r=g","width":96,"height":96,"caption":"Leonid Mamchenkov"}},{"@type":"Person","@id":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/#author","url":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/","name":"Leonid Mamchenkov","image":{"@type":"ImageObject","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/3cf6df002a284d78fb6e9d8222ca4d102e0832035ed6bc8447008bd234e131a4?s=96&d=identicon&r=g","width":96,"height":96,"caption":"Leonid Mamchenkov"}},{"@type":"WebPage","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/#webpage","url":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/","name":"SOAR \u2013 SQL Optimizer And Rewriter - Leonid Mamchenkov","description":"SOAR is an SQL Optimizer and Rewriter. It can help analyse, optimize, and rewrite SQL queries. Don't get offset by the Chinese documentation as default - there is an English translation. Here are some of the features: Cross-platform support, such as Linux, Mac, and Windows Support Heuristic Rules Suggestion Support Complicate SQL Indexing Optimize","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/mamchenkov.net\/wordpress\/#website"},"breadcrumb":{"@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/#breadcrumblist"},"author":{"@id":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/#author"},"creator":{"@id":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/#author"},"datePublished":"2018-10-29T08:43:26+02:00","dateModified":"2018-10-29T08:45:04+02:00"},{"@type":"WebSite","@id":"https:\/\/mamchenkov.net\/wordpress\/#website","url":"https:\/\/mamchenkov.net\/wordpress\/","name":"Blog of Leonid Mamchenkov","description":"Life, universe, and everything else","inLanguage":"en-US","publisher":{"@id":"https:\/\/mamchenkov.net\/wordpress\/#person"}}]},"og:locale":"en_US","og:site_name":"Leonid Mamchenkov - Life, universe, and everything else","og:type":"article","og:title":"SOAR \u2013 SQL Optimizer And Rewriter - Leonid Mamchenkov","og:description":"SOAR is an SQL Optimizer and Rewriter. It can help analyse, optimize, and rewrite SQL queries. Don't get offset by the Chinese documentation as default - there is an English translation. Here are some of the features: Cross-platform support, such as Linux, Mac, and Windows Support Heuristic Rules Suggestion Support Complicate SQL Indexing Optimize","og:url":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/","og:image":"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg","og:image:secure_url":"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg","og:image:width":1024,"og:image:height":1024,"article:published_time":"2018-10-29T06:43:26+00:00","article:modified_time":"2018-10-29T06:45:04+00:00","article:publisher":"https:\/\/www.facebook.com\/MamchenkovBlog","twitter:card":"summary_large_image","twitter:site":"@mamchenkov","twitter:title":"SOAR \u2013 SQL Optimizer And Rewriter - Leonid Mamchenkov","twitter:description":"SOAR is an SQL Optimizer and Rewriter. It can help analyse, optimize, and rewrite SQL queries. Don't get offset by the Chinese documentation as default - there is an English translation. Here are some of the features: Cross-platform support, such as Linux, Mac, and Windows Support Heuristic Rules Suggestion Support Complicate SQL Indexing Optimize","twitter:creator":"@mamchenkov","twitter:image":"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg"},"aioseo_meta_data":{"post_id":"28898","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2023-07-20 05:29:42","updated":"2026-01-15 13:49:45","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/mamchenkov.net\/wordpress\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/\" title=\"Technology\">Technology<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/programming\/\" title=\"Programming\">Programming<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tSOAR \u2013 SQL Optimizer And Rewriter\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/mamchenkov.net\/wordpress"},{"label":"Technology","link":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/"},{"label":"Programming","link":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/programming\/"},{"label":"SOAR &#8211; SQL Optimizer And Rewriter","link":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/"}],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":28562,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/05\/08\/database-flow-modern-self-hosted-web-interface-for-sql-and-graphql\/","url_meta":{"origin":28898,"position":0},"title":"Database Flow &#8211; modern, self-hosted web interface for SQL and GraphQL","author":"Leonid Mamchenkov","date":"May 8, 2018","format":false,"excerpt":"Database Flow is a modern, Open Source, self-hosted, web-based tool for working with SQL databases and GraphQL APIs.\u00a0 It supports a variety of the database engines: IBM DB2, Oracle, H2, PostgreSQL, MySQL, SQLite, Informix, and Microsoft SQL Server.\u00a0 It features an advanced SQL editor, query plan analyzer, GraphQL client, schema\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/05\/database-flow-500x281.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":28425,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/","url_meta":{"origin":28898,"position":1},"title":"SQLBolt &#8211; Learn SQL with simple, interactive exercises","author":"Leonid Mamchenkov","date":"March 9, 2018","format":false,"excerpt":"SQLBolt is by far the best SQL tutorial that I've ever seen!\u00a0 Yes, I know, it's a very bold statement.\u00a0 But I promise that it's true. With hundreds of books, videos, and other tutorials around, the problem of delivering the understanding of data management, databases, and SQL to regular people\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/03\/sqlbolt-500x366.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":24512,"url":"https:\/\/mamchenkov.net\/wordpress\/2015\/07\/28\/sql-style-guide\/","url_meta":{"origin":28898,"position":2},"title":"SQL Style Guide","author":"Leonid Mamchenkov","date":"July 28, 2015","format":"link","excerpt":"SQL Style Guide - much needed!","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":24803,"url":"https:\/\/mamchenkov.net\/wordpress\/2015\/10\/03\/sql-vs-nosql-how-to-choose\/","url_meta":{"origin":28898,"position":3},"title":"SQL vs NoSQL: How to Choose","author":"Leonid Mamchenkov","date":"October 3, 2015","format":false,"excerpt":"\"SQL vs NoSQL: How to Choose\" article continues the discussion of SQL vs. NoSQL from the \"SQL vs NoSQL: The Differences\" article. \u00a0Both should be read in full. \u00a0But I'll keep the summary here for future use. SQL databases: store related data in tables require a schema which defines tables\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28508,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/04\/20\/mysql-8-0-release\/","url_meta":{"origin":28898,"position":4},"title":"MySQL 8.0 release","author":"Leonid Mamchenkov","date":"April 20, 2018","format":false,"excerpt":"MySQL 8.0 has been released and it brings the following new features, enhancements, and more: SQL\u00a0Window functions, Common Table Expressions, NOWAIT and SKIP LOCKED, Descending Indexes, Grouping, Regular Expressions, Character Sets, Cost Model, and Histograms. JSON\u00a0Extended syntax, new functions, improved sorting, and partial updates. With JSON table functions you can\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26157,"url":"https:\/\/mamchenkov.net\/wordpress\/2016\/06\/03\/www-sql-designer\/","url_meta":{"origin":28898,"position":5},"title":"WWW SQL Designer","author":"Leonid Mamchenkov","date":"June 3, 2016","format":false,"excerpt":"I came across the WWW SQL Designer today, and I have only one thing to say... Holy Molly! \u00a0I've been looking for a tool like this for a long long time! \u00a0It is a web-based database designer, which can export designs into MySQL. \u00a0It's super easy to use and it\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"www sql designer","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2016\/06\/www-sql-designer-500x377.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/28898","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/comments?post=28898"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/28898\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=28898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=28898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=28898"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=28898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}