{"id":73324,"date":"2012-04-10T14:05:25","date_gmt":"2012-04-10T14:05:25","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/uncategorized\/oracle-cost-based-optimizer-basics-webinar\/"},"modified":"2021-07-14T13:07:59","modified_gmt":"2021-07-14T13:07:59","slug":"oracle-cost-based-optimizer-basics-webinar","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/oracle-databases\/oracle-cost-based-optimizer-basics-webinar\/","title":{"rendered":"Oracle Cost-Based Optimizer Basics"},"content":{"rendered":"<p>This video and set of resources is a follow up to the <a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/deployment-suite-for-oracle\/webinars\/webinar-randolf-geist-oracle-cost-based-optimizer\" target=\"blank\">webinar<\/a> broadcast by <a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/\" target-\"blank\">Red Gate<\/a> on 11 Apr 2012.<\/p>\n<p><a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/deployment-suite-for-oracle\/education\/webinars\/webinar-randolf-geist-oracle-cost-based-optimizer\" target=\"blank\"><button class=\"btn\"><span>Watch video<\/span><\/button><\/a><\/p>\n<p>The video above is accompanied by the following downloadable resources: <\/p>\n<ul>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/04\/README.TXT\" target=\"blank\">Read me<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/04\/Oracle Cost-Based Optimizer Basics Webinar Slides.pdf\" target=\"blank\">Presentation slides &#8211; PDF version<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/04\/Oracle Cost-Based Optimizer Basics Webinar Slides.pptx\" target=\"blank\">Presentation slides &#8211; PowerPoint version<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/04\/Oracle Cost-Based Optimizer Basics Screenshots Demo1.pdf\" target=\"blank\">Screenshots &#8211; Demo 1 (.pdf)<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/04\/Oracle Cost-Based Optimizer Basics Screenshots Demo2.pdf\" target=\"blank\">Screenshots &#8211; Demo 2 (.pdf)<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/04\/Oracle Cost-Based Optimizer Basics Screenshots Demo3.pdf\" target=\"blank\">Screenshots &#8211; Demo 3 (.pdf)<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/04\/optimizer_basics_inter_table_clustering_testcase.sql\" target=\"blank\">optimizer_basics_inter_table_clustering_testcase.sql<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/04\/optimizer_basics_join_cardinality_testcase.sql\" target=\"blank\">optimizer_basics_join_cardinality_testcase.sql<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/04\/optimizer_basics_single_table_cardinality_testcase.sql\" target=\"blank\">optimizer_basics_single_table_cardinality_testcase.sql<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/04\/xplan_extended_display_cursor.sql\" target=\"blank\">xplan_extended_display_cursor.sql<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/04\/Oracle Cost-Based Optimizer Webinar Resources.zip\" target=\"blank\">Download all resources (.zip)<\/a><\/li>\n<\/ul>\n<p>When it comes to writing efficient queries there are a few key concepts that need to be understood. One of them is the Oracle Cost-Based Optimizer (CBO). Although it&#8217;s called a cost-based optimizer it&#8217;s actually not the cost we need to focus on primarily to understand why the optimizer makes certain decisions.<\/p>\n<p>In this webinar, you will learn the basics of the CBO, see why it is crucial that the optimizer&#8217;s picture of the data fits reality, why cardinality and selectivity estimates matter so much, and which key concepts the optimizer&#8217;s model surprisingly doesn&#8217;t cover (yet).<\/p>\n<p>Live demos throughout the presentation will enable you to see the CBO in action, and you will learn about leading the optimizer in the right direction when your knowledge of the data is better than the optimizer&#8217;s.<\/p>\n<p>A live Q+A session with Randolf Geist follows the presentation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This video and set of resources is a follow up to the webinar broadcast by Red Gate on 11 Apr 2012. Watch video The video above is accompanied by the following downloadable resources: Read me Presentation slides &#8211; PDF version Presentation slides &#8211; PowerPoint version Screenshots &#8211; Demo 1 (.pdf) Screenshots &#8211; Demo 2 (.pdf) Screenshots &#8211; Demo 3 (.pdf)&hellip;<\/p>\n","protected":false},"author":316197,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143533],"tags":[],"coauthors":[],"class_list":["post-73324","post","type-post","status-publish","format-standard","hentry","category-oracle-databases"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/316197"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=73324"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73324\/revisions"}],"predecessor-version":[{"id":91772,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73324\/revisions\/91772"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=73324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=73324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=73324"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=73324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}