{"id":31,"date":"2011-01-03T16:04:50","date_gmt":"2011-01-03T15:04:50","guid":{"rendered":"http:\/\/blog.lookee.it\/?p=31"},"modified":"2023-01-22T12:47:33","modified_gmt":"2023-01-22T10:47:33","slug":"sql-tuning","status":"publish","type":"post","link":"https:\/\/www.lucaamore.com\/?p=31","title":{"rendered":"SQL Tuning"},"content":{"rendered":"<p><a href=\"http:\/\/www.amazon.com\/SQL-Tuning-Dan-Tow\/dp\/0596005733\/\">Dan Tow, SQL Tuning, O&#8217;Reilly Media<\/a><\/p>\n<p><a href=\"https:\/\/www.lucaamore.com\/wp-content\/uploads\/2011\/01\/sqltuning.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-34\" title=\"SQL Tuning\" src=\"https:\/\/www.lucaamore.com\/wp-content\/uploads\/2011\/01\/sqltuning.gif\" alt=\"\" width=\"180\" height=\"236\" \/><\/a><\/p>\n<p>Anche se non si tratta di una pubblicazione recentissima, consiglio questo libro a tutti coloro che intendono consolidare la propria comprensione sulle basi del funzionamento interno dei principali DB.<\/p>\n<p>Solo dopo aver esposto questi meccanismi, il libro guida il lettore verso l&#8217;analisi dei vari piani di esecuzione e del loro condizionamento al fine di migliorarne efficienza e robustezza.<\/p>\n<p>Gli esempi fanno riferimento a vecchie versioni di Oracle, DB2, SQL Server; tuttavia i concetti base illustrati, poich\u00e8 quasi sempre non legati alle varie implementazioni, possono essere estesi facilmente a tutti i possibili DB relazionali.<\/p>\n<p><a href=\"https:\/\/www.lucaamore.com\/wp-content\/uploads\/2011\/01\/lukelv_dont_stop_looking_for_best_results_robots_mathematics_ph_61b535e9-e1b4-44da-ba8a-4d81e1316747.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1683\" src=\"https:\/\/www.lucaamore.com\/wp-content\/uploads\/2011\/01\/lukelv_dont_stop_looking_for_best_results_robots_mathematics_ph_61b535e9-e1b4-44da-ba8a-4d81e1316747-1024x1024.png\" alt=\"\" width=\"584\" height=\"584\" srcset=\"https:\/\/www.lucaamore.com\/wp-content\/uploads\/2011\/01\/lukelv_dont_stop_looking_for_best_results_robots_mathematics_ph_61b535e9-e1b4-44da-ba8a-4d81e1316747.png 1024w, https:\/\/www.lucaamore.com\/wp-content\/uploads\/2011\/01\/lukelv_dont_stop_looking_for_best_results_robots_mathematics_ph_61b535e9-e1b4-44da-ba8a-4d81e1316747-300x300.png 300w, https:\/\/www.lucaamore.com\/wp-content\/uploads\/2011\/01\/lukelv_dont_stop_looking_for_best_results_robots_mathematics_ph_61b535e9-e1b4-44da-ba8a-4d81e1316747-150x150.png 150w, https:\/\/www.lucaamore.com\/wp-content\/uploads\/2011\/01\/lukelv_dont_stop_looking_for_best_results_robots_mathematics_ph_61b535e9-e1b4-44da-ba8a-4d81e1316747-768x768.png 768w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dan Tow, SQL Tuning, O&#8217;Reilly Media Anche se non si tratta di una pubblicazione recentissima, consiglio questo libro a tutti coloro che intendono consolidare la propria comprensione sulle basi del funzionamento interno dei principali DB. Solo dopo aver esposto questi &hellip; <a href=\"https:\/\/www.lucaamore.com\/?p=31\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":1687,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_sitemap_exclude":false,"_sitemap_priority":"","_sitemap_frequency":"","footnotes":""},"categories":[3,4,7,6,8],"tags":[93,91,92],"class_list":["post-31","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-libri","category-oracle","category-review","category-sql","tag-book","tag-sql","tag-tuning"],"_links":{"self":[{"href":"https:\/\/www.lucaamore.com\/index.php?rest_route=\/wp\/v2\/posts\/31","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lucaamore.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lucaamore.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lucaamore.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lucaamore.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=31"}],"version-history":[{"count":24,"href":"https:\/\/www.lucaamore.com\/index.php?rest_route=\/wp\/v2\/posts\/31\/revisions"}],"predecessor-version":[{"id":1684,"href":"https:\/\/www.lucaamore.com\/index.php?rest_route=\/wp\/v2\/posts\/31\/revisions\/1684"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.lucaamore.com\/index.php?rest_route=\/wp\/v2\/media\/1687"}],"wp:attachment":[{"href":"https:\/\/www.lucaamore.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=31"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lucaamore.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=31"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lucaamore.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}