{"id":4670,"date":"2021-10-26T06:35:46","date_gmt":"2021-10-26T06:35:46","guid":{"rendered":"https:\/\/www.idera.com\/?page_id=4670"},"modified":"2024-03-28T08:57:30","modified_gmt":"2024-03-28T13:57:30","slug":"overview","status":"publish","type":"page","link":"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/","title":{"rendered":"DB Optimizer | SQL Database Optimization"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f5f5f4&#8243; overflow-x=&#8221;visible&#8221; overflow-y=&#8221;visible&#8221; custom_margin=&#8221;||34px||false|false&#8221; custom_padding=&#8221;40px||0px||false|false&#8221; sticky_position=&#8221;top&#8221; sticky_position_tablet=&#8221;&#8221; sticky_position_phone=&#8221;none&#8221; sticky_position_last_edited=&#8221;on|desktop&#8221; da_disable_devices=&#8221;off|off|off&#8221; global_colors_info=&#8221;{}&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; max_width=&#8221;1044px&#8221; custom_padding=&#8221;0px||0px||true|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text module_class=&#8221;tool-t-text&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#95c93d&#8221; header_font_size=&#8221;28px&#8221; header_2_font=&#8221;||on||||||&#8221; header_2_text_color=&#8221;#5a5143&#8243; header_2_font_size=&#8221;21px&#8221; custom_margin=&#8221;||22px||false|false&#8221; header_font_size_tablet=&#8221;25px&#8221; header_font_size_phone=&#8221;22px&#8221; header_font_size_last_edited=&#8221;on|phone&#8221; header_2_font_size_tablet=&#8221;20px&#8221; header_2_font_size_phone=&#8221;18px&#8221; header_2_font_size_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>Database Query Tuning for Multiple Platforms<\/h1>\n<h2 id=\"content_0_productSubheading\" class=\"product-heading product-subheading-icon\"><img decoding=\"async\" src=\"https:\/\/www.idera.com\/wp-content\/uploads\/2021\/10\/emb-DBOptimizer.png\" width=\"32\" height=\"32\" alt=\"DB Optimizer \" class=\"wp-image-4655 alignnone size-full\"> DB Optimizer<\/h2>\n<p>[\/et_pb_text][et_pb_code disabled_on=&#8221;on|on|off&#8221; _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;||-14px||false|false&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]  <a href=\"\/dboptimizer-sql-database-optimization\/freetrialsubscriptionform\/\" class=\"SubNavCTA sbtn\">  Start for FREE<\/a>    <!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->  <a class=\"sub-m-toggle\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/2021\/09\/mobile-icon.png\" alt=\"mobile-icon\"><\/a><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><\/p>\n<ul class=\"tool-nav subbar-nav\"><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> \t<\/p>\n<li><a href=\"\/dboptimizer-sql-database-optimization\/overview\/\" class=\"active\"> <img decoding=\"async\" src=\"\/wp-content\/uploads\/2021\/10\/nav-icon-eye.png\" alt=\"nav-icon-eye\"> <span>Overview<\/span><\/a><\/li>\n<p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> \t<\/p>\n<li><a href=\"\/dboptimizer-sql-database-optimization\/productdetails\/\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/2021\/10\/nav-icon-search.png\" alt=\"nav-icon-search\"> <span>Details<\/span><\/a><\/li>\n<p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> \t<\/p>\n<li><a href=\"https:\/\/wiki.idera.com\/display\/TechSpecs\/DB+PowerStudio+DB+Optimizer+Technical+Specifications\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/2021\/10\/nav-icon-cogwheel.png\" alt=\"nav-icon-cogwheel\"> <span>Tech Specs<\/span><\/a><\/li>\n<p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> \t<\/p>\n<li><a href=\"\/dboptimizer-sql-database-optimization\/resources\/\"> <img decoding=\"async\" src=\"\/wp-content\/uploads\/2021\/10\/nav-icon-folders.png\" alt=\"nav-icon-folders\"> <span>Resources<\/span> <\/a><\/li>\n<p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> \t<\/p>\n<li><a href=\"\/dboptimizer-sql-database-optimization\/product-tour\/\"> <img decoding=\"async\" src=\"\/wp-content\/uploads\/2021\/10\/icon-Product-Tour.png\" alt=\"icon-Product-Tour\">  <span>Tour<\/span><\/a><\/li>\n<p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> \t<\/p>\n<li><a href=\"\/dboptimizer-sql-database-optimization\/freetrialsubscriptionform\/\"> <img decoding=\"async\" src=\"\/wp-content\/uploads\/2021\/10\/icon-Product-Download.png\" alt=\"icon-Product-Download\">  <span>Download<\/span><\/a><\/li>\n<p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><\/ul>\n<p>[\/et_pb_code][et_pb_code disabled_on=&#8221;off|off|on&#8221; _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;||-14px||false|false&#8221; hover_enabled=&#8221;0&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<div class=\"downloadctabtn\"><!-- [et_pb_line_break_holder] -->    <a href=\"\/dboptimizer-sql-database-optimization\/freetrialsubscriptionform\/\" class=\"SubNavCTA btncenter\"> Start for FREE <\/a>  <!-- [et_pb_line_break_holder] -->    <\/div>\n<p><!-- [et_pb_line_break_holder] -->    <!-- [et_pb_line_break_holder] -->    <select id=\"DetailSelect\" class=\"DetailSelect\" name=\"DetailSelect\"><!-- [et_pb_line_break_holder] --><option selected value=\"\/dboptimizer-sql-database-optimization\/overview\/\"> Overview <\/option><!-- [et_pb_line_break_holder] --><option  value=\"\/dboptimizer-sql-database-optimization\/productdetails\/\">Details<\/option><!-- [et_pb_line_break_holder] --><option value=\"https:\/\/wiki.idera.com\/display\/TechSpecs\/DB+PowerStudio+DB+Optimizer+Technical+Specifications\">Tech Specs<\/option><!-- [et_pb_line_break_holder] --><option  value=\"\/dboptimizer-sql-database-optimization\/resources\/\">Resources<\/option><!-- [et_pb_line_break_holder] --><option  value=\"\/dboptimizer-sql-database-optimization\/product-tour\/\">Tour<\/option><!-- [et_pb_line_break_holder] --><option   value=\"\/dboptimizer-sql-database-optimization\/freetrialsubscriptionform\/\">Download<\/option><!-- [et_pb_line_break_holder] -->    <\/select>[\/et_pb_code][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_class=&#8221;tool-content &#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;0px||70px||false|false&#8221; da_disable_devices=&#8221;off|off|off&#8221; global_colors_info=&#8221;{}&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row column_structure=&#8221;2_3,1_3&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; max_width=&#8221;1044px&#8221; custom_padding=&#8221;0px||0px||true|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; text_text_color=&#8221;#7f786d&#8221; text_font_size=&#8221;15px&#8221; text_line_height=&#8221;1.4em&#8221; ul_font=&#8221;|700|||||||&#8221; ul_text_color=&#8221;#6d6559&#8243; header_2_text_color=&#8221;#5a5143&#8243; header_2_font_size=&#8221;29px&#8221; header_2_line_height=&#8221;1.2em&#8221; header_3_font=&#8221;|700|||||||&#8221; header_3_text_color=&#8221;#5a5143&#8243; header_3_font_size=&#8221;15px&#8221; header_2_font_size_tablet=&#8221;24px&#8221; header_2_font_size_phone=&#8221;22px&#8221; header_2_font_size_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<div class=\"ProductContent\">\n<div class=\"ProductContent\">\n<div class=\"ProductContent\">\n<div class=\"ProductContent\">\n<h2>Optimize database SQL queries for multiple platforms from a single user interface<\/h2>\n<ul>\n<li>Streamline tuning of SQL code on major DBMSs from one interface<\/li>\n<li>Tune SQL like a pro with automated performance optimization suggestions<\/li>\n<li>Tackle SQL queries with visual SQL tuning diagrams<\/li>\n<li>Pinpoint problem SQL with database profiling of wait-time analysis<\/li>\n<li>Load test alternative SQL queries in simulated production environment<\/li>\n<\/ul>\n<h3>Streamline SQL Tuning Across Major DBMSs<\/h3>\n<p>Tune poorly performing SQL code on all major DBMSs (SQL Server, Oracle Database, Sybase ASE, and Db2 LUW, and PostgreSQL) from a single common interface. Reduce training requirements and streamline collaboration among teams across the organization.<\/p>\n<h3>Tune SQL Like a Pro!<\/h3>\n<p>The SQL tuning wizard automatically suggests solutions and provides essential context in tuning SQL code. Color-coded Index Analysis shows used, not used, or missing indexes and offers recommenda\u00adtions for optimum performance. Case Generation is used to generate all possible cases and to find the best alternative to a given SQL statement by including SQL rewrites and hint injections.<\/p>\n<h3>Visually Tackle SQL Queries<\/h3>\n<p>Unique in the industry, Visual SQL Tuning (VST) diagrams turn text-based SQL code into graphical SQL diagrams. This approach helps DBAs and developers understand the impact of SQL statements on the database. The VST diagram displays indexes and constraints on tables and views with table statistics, as well as the joins used in a SQL statement such as Cartesian joins, implied Cartesian joins and many-to-many relationships.<\/p>\n<h3>Identify Performance Bottlenecks Immediately<\/h3>\n<p>Database profiling provides a graphical visualization of wait-time anal\u00adysis, making the SQL that is causing poor database performance easy to pinpoint. Continuous profiling monitors an entire data source within a configurable span of time. Also, explain plans are provided for a better understanding of how SQL will be executed and the performance costs. Utilize reporting to allow sharing of information captured during the profiling process.<\/p>\n<h3>Simulate Production Environments<\/h3>\n<p>Load testing verifies performance of existing and alternative SQL queries against the database. Configure queries to run multiple times in parallel and see how they respond to your simulated production environment without the risk of actually testing in production.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_image src=&#8221;https:\/\/www.idera.com\/wp-content\/uploads\/2021\/10\/free-callout-top.png&#8221; alt=&#8221;free-callout-top&#8221; title_text=&#8221;free-callout-top&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.21.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][et_pb_image src=&#8221;https:\/\/www.idera.com\/wp-content\/uploads\/2021\/10\/DBOptimizer-Hero.png&#8221; alt=&#8221;DBOptimizer-Hero&#8221; title_text=&#8221;DBOptimizer-Hero&#8221; url=&#8221;\/dboptimizer-sql-database-optimization\/product-tour&#8221; _builder_version=&#8221;4.21.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; text_text_color=&#8221;#5a5143&#8243; text_font_size=&#8221;14px&#8221; text_line_height=&#8221;1.4em&#8221; header_4_font=&#8221;|700|||||||&#8221; header_4_text_color=&#8221;#c8c5c0&#8243; header_4_font_size=&#8221;20px&#8221; max_width=&#8221;260px&#8221; module_alignment=&#8221;center&#8221; custom_margin=&#8221;||37px||false|false&#8221; custom_padding=&#8221;|||20px|false|false&#8221; hover_enabled=&#8221;0&#8243; border_width_left=&#8221;5px&#8221; border_color_left=&#8221;#def2f8&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h4>Buy Now<\/h4>\n<p>Starts at <span style=\"text-decoration: line-through;\">$715.00<\/span> $572.00 per user (workstation)<\/p>\n<p>Save at least 20% on all online purchases.<br \/>\nVolume discounts available.<\/p>\n<p><a class=\"SidebarAddToCartCTA\" href=\"https:\/\/store.idera.com\/buynow\/onlinestore\/?ptid=%7BAB9650F5-FB7C-439F-BFCE-395A1817728B%7D#DBOptimizer\">Add to Cart<\/a><br \/>\n<a class=\"SidebarRequestQuoteCTA\" href=\"\/dboptimizer-sql-database-optimization\/requestaquote\/\">Request a Quote<\/a>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; text_text_color=&#8221;#5a5143&#8243; text_font_size=&#8221;14px&#8221; text_line_height=&#8221;1.4em&#8221; header_4_font=&#8221;|700|||||||&#8221; header_4_text_color=&#8221;#c8c5c0&#8243; header_4_font_size=&#8221;20px&#8221; max_width=&#8221;260px&#8221; module_alignment=&#8221;center&#8221; custom_padding=&#8221;|||20px|false|false&#8221; hover_enabled=&#8221;0&#8243; border_width_left=&#8221;5px&#8221; border_color_left=&#8221;#def2f8&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h4>Live Product Demo<\/h4>\n<p>See DB Optimizer in action with a seasoned pro.<\/p>\n<p><a href=\"\/dboptimizer-sql-database-optimization\/requestademo\/\" class=\"SidebarRequestDemoCTA\">Request a Demo<\/a><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; custom_padding_last_edited=&#8221;on|desktop&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f5f5f4&#8243; custom_margin=&#8221;||0px||false|false&#8221; custom_padding=&#8221;40px||20px||false|false&#8221; custom_padding_tablet=&#8221;30px||30px||true|false&#8221; custom_padding_phone=&#8221;&#8221; da_disable_devices=&#8221;off|off|off&#8221; global_colors_info=&#8221;{}&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row module_class=&#8221; inline-block&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; max_width=&#8221;1044px&#8221; module_alignment=&#8221;center&#8221; custom_padding=&#8221;0px||0px||true|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_button button_url=&#8221;\/dboptimizer-sql-database-optimization\/freetrialsubscriptionform\/&#8221; button_text=&#8221;Start for FREE&#8221; _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;28px&#8221; button_bg_color=&#8221;#95c93d&#8221; button_border_radius=&#8221;0px&#8221; button_font=&#8221;|800|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;||20px||false|false&#8221; custom_padding=&#8221;11px|30px|11px|30px|true|true&#8221; hover_enabled=&#8221;0&#8243; button_text_size_tablet=&#8221;23px&#8221; button_text_size_phone=&#8221;20px&#8221; button_text_size_last_edited=&#8221;on|phone&#8221; button_bg_color_last_edited=&#8221;off|desktop&#8221; custom_css_main_element=&#8221; text-transform: none !important;&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|desktop&#8221; button_bg_color__hover=&#8221;#76a03f&#8221; button_bg_enable_color__hover=&#8221;on&#8221; sticky_enabled=&#8221;0&#8243;][\/et_pb_button][et_pb_image src=&#8221;https:\/\/www.idera.com\/wp-content\/uploads\/2021\/10\/free-callout-top.png&#8221; alt=&#8221;giveitatry-callout-bottom&#8221; title_text=&#8221;free-callout-top&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.21.2&#8243; _module_preset=&#8221;default&#8221; module_alignment=&#8221;left&#8221; custom_margin=&#8221;10px||20px||false|false&#8221; custom_padding=&#8221;|||20px|false|false&#8221; custom_padding_tablet=&#8221;&#8221; custom_padding_phone=&#8221;&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; custom_css_main_element=&#8221;display: inline-block; &#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tune SQL like a pro with DB Optimizer, IDERA&#39;s SQL database optimization tool, which offers performance optimization suggestions, visual tuning diagrams and more.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":4650,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"<!-- wp:divi\/placeholder \/-->","_et_gb_content_width":"","footnotes":""},"class_list":["post-4670","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DB Optimizer | SQL Database Optimization | IDERA<\/title>\n<meta name=\"description\" content=\"Tune SQL like a pro with DB Optimizer, IDERA&#039;s SQL database optimization tool, which offers performance optimization suggestions, visual tuning diagrams and more.\" \/>\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.idera.com\/dboptimizer-sql-database-optimization\/overview\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DB Optimizer | SQL Database Optimization\" \/>\n<meta property=\"og:description\" content=\"Tune SQL like a pro with DB Optimizer, IDERA&#039;s SQL database optimization tool, which offers performance optimization suggestions, visual tuning diagrams and more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/\" \/>\n<meta property=\"og:site_name\" content=\"IDERA\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T13:57:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.idera.com\/wp-content\/uploads\/2021\/10\/emb-DBOptimizer.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/\",\"url\":\"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/\",\"name\":\"DB Optimizer | SQL Database Optimization | IDERA\",\"isPartOf\":{\"@id\":\"https:\/\/www.idera.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.idera.com\/wp-content\/uploads\/2021\/10\/emb-DBOptimizer.png\",\"datePublished\":\"2021-10-26T06:35:46+00:00\",\"dateModified\":\"2024-03-28T13:57:30+00:00\",\"description\":\"Tune SQL like a pro with DB Optimizer, IDERA&#39;s SQL database optimization tool, which offers performance optimization suggestions, visual tuning diagrams and more.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/#primaryimage\",\"url\":\"https:\/\/www.idera.com\/wp-content\/uploads\/2021\/10\/emb-DBOptimizer.png\",\"contentUrl\":\"https:\/\/www.idera.com\/wp-content\/uploads\/2021\/10\/emb-DBOptimizer.png\",\"width\":32,\"height\":32,\"caption\":\"DB Optimizer\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.idera.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DB Optimizer | SQL Database Optimization\",\"item\":\"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DB Optimizer | SQL Database Optimization\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.idera.com\/#website\",\"url\":\"https:\/\/www.idera.com\/\",\"name\":\"IDERA\",\"description\":\"SQL Server, Database Management, and IT Performance Tools\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.idera.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"DB Optimizer | SQL Database Optimization | IDERA","description":"Tune SQL like a pro with DB Optimizer, IDERA&#39;s SQL database optimization tool, which offers performance optimization suggestions, visual tuning diagrams and more.","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.idera.com\/dboptimizer-sql-database-optimization\/overview\/","og_locale":"en_US","og_type":"article","og_title":"DB Optimizer | SQL Database Optimization","og_description":"Tune SQL like a pro with DB Optimizer, IDERA&#39;s SQL database optimization tool, which offers performance optimization suggestions, visual tuning diagrams and more.","og_url":"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/","og_site_name":"IDERA","article_modified_time":"2024-03-28T13:57:30+00:00","og_image":[{"url":"https:\/\/www.idera.com\/wp-content\/uploads\/2021\/10\/emb-DBOptimizer.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/","url":"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/","name":"DB Optimizer | SQL Database Optimization | IDERA","isPartOf":{"@id":"https:\/\/www.idera.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/#primaryimage"},"image":{"@id":"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/#primaryimage"},"thumbnailUrl":"https:\/\/www.idera.com\/wp-content\/uploads\/2021\/10\/emb-DBOptimizer.png","datePublished":"2021-10-26T06:35:46+00:00","dateModified":"2024-03-28T13:57:30+00:00","description":"Tune SQL like a pro with DB Optimizer, IDERA&#39;s SQL database optimization tool, which offers performance optimization suggestions, visual tuning diagrams and more.","breadcrumb":{"@id":"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/#primaryimage","url":"https:\/\/www.idera.com\/wp-content\/uploads\/2021\/10\/emb-DBOptimizer.png","contentUrl":"https:\/\/www.idera.com\/wp-content\/uploads\/2021\/10\/emb-DBOptimizer.png","width":32,"height":32,"caption":"DB Optimizer"},{"@type":"BreadcrumbList","@id":"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/overview\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.idera.com\/"},{"@type":"ListItem","position":2,"name":"DB Optimizer | SQL Database Optimization","item":"https:\/\/www.idera.com\/dboptimizer-sql-database-optimization\/"},{"@type":"ListItem","position":3,"name":"DB Optimizer | SQL Database Optimization"}]},{"@type":"WebSite","@id":"https:\/\/www.idera.com\/#website","url":"https:\/\/www.idera.com\/","name":"IDERA","description":"SQL Server, Database Management, and IT Performance Tools","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.idera.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.idera.com\/wp-json\/wp\/v2\/pages\/4670"}],"collection":[{"href":"https:\/\/www.idera.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.idera.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.idera.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.idera.com\/wp-json\/wp\/v2\/comments?post=4670"}],"version-history":[{"count":14,"href":"https:\/\/www.idera.com\/wp-json\/wp\/v2\/pages\/4670\/revisions"}],"predecessor-version":[{"id":49842,"href":"https:\/\/www.idera.com\/wp-json\/wp\/v2\/pages\/4670\/revisions\/49842"}],"up":[{"embeddable":true,"href":"https:\/\/www.idera.com\/wp-json\/wp\/v2\/pages\/4650"}],"wp:attachment":[{"href":"https:\/\/www.idera.com\/wp-json\/wp\/v2\/media?parent=4670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}