{"id":106638,"date":"2017-08-17T17:08:24","date_gmt":"2017-08-17T15:08:24","guid":{"rendered":"http:\/\/www.danysoft.com\/?p=106638\/"},"modified":"2017-08-17T17:09:29","modified_gmt":"2017-08-17T15:09:29","slug":"statistiche-duplicate","status":"publish","type":"post","link":"https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/","title":{"rendered":"Statistiche Duplicate"},"content":{"rendered":"<div id='full_slider_1'  class='avia-fullwidth-slider main_color avia-shadow   avia-builder-el-0  el_before_av_section  avia-builder-el-first   container_wrap fullsize'  ><div  class='avia-slideshow av-av_slideshow_full-32de997090c749a8c82b86d1ff824dd4 avia-slideshow-featured av_slideshow_full avia-slide-slider av-slideshow-ui av-control-default av-slideshow-manual av-loop-once av-loop-manual-endless av-default-height-applied   avia-slideshow-1' data-slideshow-options=\"{&quot;animation&quot;:&quot;slide&quot;,&quot;autoplay&quot;:false,&quot;loop_autoplay&quot;:&quot;once&quot;,&quot;interval&quot;:5,&quot;loop_manual&quot;:&quot;manual-endless&quot;,&quot;autoplay_stopper&quot;:false,&quot;noNavigation&quot;:false,&quot;bg_slider&quot;:false,&quot;keep_padding&quot;:false,&quot;hoverpause&quot;:false,&quot;show_slide_delay&quot;:0}\"  itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><ul class='avia-slideshow-inner ' style='padding-bottom: 28.666666666667%;'><li  class='avia-slideshow-slide av-av_slideshow_full-32de997090c749a8c82b86d1ff824dd4__0  av-single-slide slide-1 slide-odd'><div data-rel='slideshow-1' class='avia-slide-wrap '   ><div class='av-slideshow-caption av-av_slideshow_full-32de997090c749a8c82b86d1ff824dd4__0 caption_fullwidth caption_center caption_center_framed caption_framed'><div class=\"container caption_container\"><div class=\"slideshow_caption\"><div class=\"slideshow_inner_caption\"><div class=\"slideshow_align_caption\"><h2 class='avia-caption-title '  itemprop=\"name\" >Statistiche Duplicate<\/h2><div class='avia-caption-content av_inherit_color'  itemprop=\"description\" ><p>Cosa fare per cercarle e como aggire quando le troviamo<\/p>\n<\/div><\/div><\/div><\/div><\/div><\/div><img decoding=\"async\" fetchpriority=\"high\" class=\"wp-image-122914 avia-img-lazy-loading-not-122914\"  src=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/stormtrooper-1500x430.jpg\" width=\"1500\" height=\"430\" title='Estad\u00edsticas duplicadas' alt=''  itemprop=\"thumbnailUrl\"   \/><\/div><\/li><\/ul><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_section-9a3e40f2ca4bcd5537b15e258a5a50d4\">\n.avia-section.av-av_section-9a3e40f2ca4bcd5537b15e258a5a50d4{\nbackground-color:#ed9807;\nbackground-image:unset;\n}\n.avia-section.av-av_section-9a3e40f2ca4bcd5537b15e258a5a50d4 .av-extra-border-element .av-extra-border-inner{\nbackground-color:#ed9807;\n}\n<\/style>\n<div id='av_section_1'  class='avia-section av-av_section-9a3e40f2ca4bcd5537b15e258a5a50d4 main_color avia-section-default avia-no-border-styling  avia-builder-el-1  el_after_av_slideshow_full  el_before_av_section  avia-bg-style-scroll av-arrow-down-section container_wrap fullsize'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-full alpha units'><div class='post-entry post-entry-type-page post-entry-106638'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3\">\n#top .av_textblock_section.av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 .avia_textblock{\ncolor:#ffffff;\n}\n<\/style>\n<section  class='av_textblock_section av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><h1 style=\"text-align: center;\">L\u2019esistenza di statistiche duplicate<\/h1>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3\">\n#top .av_textblock_section.av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 .avia_textblock{\ncolor:#ffffff;\n}\n<\/style>\n<section  class='av_textblock_section av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><h3 style=\"text-align: center;\">Introduzione<\/h3>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-fbebcb4fe7f7f93a621d8b6783460008\">\n#top .hr.hr-invisible.av-av_hr-fbebcb4fe7f7f93a621d8b6783460008{\nheight:30px;\n}\n<\/style>\n<div  class='hr av-av_hr-fbebcb4fe7f7f93a621d8b6783460008 hr-invisible  avia-builder-el-4  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3\">\n#top .av_textblock_section.av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 .avia_textblock{\ncolor:#ffffff;\n}\n<\/style>\n<section  class='av_textblock_section av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><p style=\"text-align: center;\">Anche se l\u2019esistenza di statistiche doppie non genera problemi perch\u00e9 occupano poco spazio e non affeta al rendimento, ci pu\u00f2 essere utile controlare le pi\u00f9 grosse per cancelarle e abassare il tempo di manutenzione, ci possono dare idee di indici dippi.<\/p>\n<\/div><\/section>\n<\/div><\/div><\/div><!-- close content main div --><\/div><div class='av-extra-border-element border-extra-arrow-down'><div class='av-extra-border-outer'><div class='av-extra-border-inner'><\/div><\/div><\/div><\/div><div id='av_section_2'  class='avia-section av-av_section-bb9bdb22c7f9e6bf1d52c155825dc7f7 main_color avia-section-default avia-no-shadow  avia-builder-el-6  el_after_av_section  el_before_av_section  avia-bg-style-scroll container_wrap fullsize'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-full alpha units'><div class='post-entry post-entry-type-page post-entry-106638'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_full-6126cab7d8fab8d08143dd2dacdf673c\">\n.flex_column.av-av_one_full-6126cab7d8fab8d08143dd2dacdf673c{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_one_full-6126cab7d8fab8d08143dd2dacdf673c av_one_full  avia-builder-el-7  el_before_av_hr  avia-builder-el-first  first flex_column_div av-zero-column-padding  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_textblock-3ab19dbd254fedf598017c70d99d0e98\">\n#top .av_textblock_section.av-av_textblock-3ab19dbd254fedf598017c70d99d0e98 .avia_textblock{\ncolor:#0f4589;\n}\n<\/style>\n<section  class='av_textblock_section av-av_textblock-3ab19dbd254fedf598017c70d99d0e98 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><h1 style=\"text-align: center;\">CERCARE DUPLICATI<\/h1>\n<\/div><\/section><br \/>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-fbebcb4fe7f7f93a621d8b6783460008\">\n#top .hr.hr-invisible.av-av_hr-fbebcb4fe7f7f93a621d8b6783460008{\nheight:30px;\n}\n<\/style>\n<div  class='hr av-av_hr-fbebcb4fe7f7f93a621d8b6783460008 hr-invisible  avia-builder-el-9  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div><br \/>\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p style=\"text-align: center;\">Per cercare quali statistiche o indici duplicati, ci bassiamo nel primo capo. Questo si deve a che le statistiche automatiche sono su un campo; b\/ le statistiche d\u2019usuario possono andare suvari campi, ma \u00e8 il primo quello che ci pu\u00f2 indicare i duplicati; e c\/ nel caso degl\u2019indici, se due iniziano con lo stesso campo, dobbiamo analizzare se uno copre l\u2019altro o se sono necessari tutti e due. Quindi no cerchiamo coincidenze esatte, ma segni che possono esistere statistiche o indici duplicati, quindi, migliora il rendimento se gli eliminiamo.<\/p>\n<\/div><\/section><\/p><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-fbebcb4fe7f7f93a621d8b6783460008\">\n#top .hr.hr-invisible.av-av_hr-fbebcb4fe7f7f93a621d8b6783460008{\nheight:30px;\n}\n<\/style>\n<div  class='hr av-av_hr-fbebcb4fe7f7f93a621d8b6783460008 hr-invisible  avia-builder-el-11  el_after_av_one_full  el_before_av_three_fifth '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_three_fifth-15d750bd1b332b34c6e70b077ebbccdf\">\n.flex_column.av-av_three_fifth-15d750bd1b332b34c6e70b077ebbccdf{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_three_fifth-15d750bd1b332b34c6e70b077ebbccdf av_three_fifth  avia-builder-el-12  el_after_av_hr  el_before_av_one_third  first flex_column_div av-zero-column-padding  '     ><section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p style=\"text-align: left;\">Per quello, per ogni base di dati cerchiamo in tutte le tabelle (sys.tables e sys.schemas) tutte le statistiche (sys.stats) e il primo campo secondo l\u2019ordine della statistica (sys.stats_columns), inoltre al nome e largo di quella colonna (sys.columns).<\/p>\n<\/div><\/section><br \/>\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p style=\"text-align: left;\">Il largo \u00e8 informativo, un\u2019altra cosa che possiamo fare \u00e8 eliminare statistiche dei campi troppo larghi, in generale non si usano nelle indagini. Cio\u00e8, in un campo grande spesso si usa LIKE per cercare in qualsiasi parte del campo, e le statistiche in generale non aiutanoin questo caso.<\/p>\n<p style=\"text-align: left;\">Se agruppiamo attraverso l\u2019identificatore del oggetto e della colonna, andremmo ad ottenere quelle statistiche che potremmo analizzare.<\/p>\n<\/div><\/section><\/p><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_third-c8fc129dc35fd1ae2a1e410224d39ea8\">\n.flex_column.av-av_one_third-c8fc129dc35fd1ae2a1e410224d39ea8{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_one_third-c8fc129dc35fd1ae2a1e410224d39ea8 av_one_third  avia-builder-el-15  el_after_av_three_fifth  avia-builder-el-last  flex_column_div av-zero-column-padding  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-9266fced178313e0b2c7784aa152f5cc\">\n.avia-image-container.av-av_image-9266fced178313e0b2c7784aa152f5cc img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-9266fced178313e0b2c7784aa152f5cc .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-9266fced178313e0b2c7784aa152f5cc av-styling- av-img-linked avia-align-right  avia-builder-el-16  avia-builder-el-no-sibling '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><a href=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/img01-529x630.png\" data-srcset=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/img01-529x630.png 529w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/img01-529x630-252x300.png 252w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/img01-529x630-450x536.png 450w\" data-sizes=\"(max-width: 529px) 100vw, 529px\" class='avia_image '  aria-label='Estad\u00edsticas duplicadas'><img decoding=\"async\" fetchpriority=\"high\" class='wp-image-123038 avia-img-lazy-loading-not-123038 avia_image ' src=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/img01-529x630-495x400.png\" alt='' title='Estad\u00edsticas duplicadas'  height=\"400\" width=\"495\"  itemprop=\"thumbnailUrl\"  \/><\/a><\/div><\/div><\/div><\/div><\/div><\/div><\/div><!-- close content main div --><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_section-8ed93ee03575af4dd393c78f367c57e6\">\n.avia-section.av-av_section-8ed93ee03575af4dd393c78f367c57e6{\nbackground-color:#0f4589;\nbackground-image:unset;\n}\n.avia-section.av-av_section-8ed93ee03575af4dd393c78f367c57e6 .av-extra-border-element .av-extra-border-inner{\nbackground-color:#0f4589;\n}\n<\/style>\n<div id='av_section_3'  class='avia-section av-av_section-8ed93ee03575af4dd393c78f367c57e6 main_color avia-section-default avia-no-shadow  avia-builder-el-17  el_after_av_section  el_before_av_section  avia-bg-style-scroll av-arrow-down-section container_wrap fullsize'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-full alpha units'><div class='post-entry post-entry-type-page post-entry-106638'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3\">\n#top .av_textblock_section.av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 .avia_textblock{\ncolor:#ffffff;\n}\n<\/style>\n<section  class='av_textblock_section av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><h1 style=\"text-align: center;\">DATI AGGIUNTIVI<\/h1>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-4474f20d2389e2e5ecf918a02da5132e\">\n#top .hr.hr-invisible.av-av_hr-4474f20d2389e2e5ecf918a02da5132e{\nheight:50px;\n}\n<\/style>\n<div  class='hr av-av_hr-4474f20d2389e2e5ecf918a02da5132e hr-invisible  avia-builder-el-19  el_after_av_textblock  el_before_av_three_fifth '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_three_fifth-6126cab7d8fab8d08143dd2dacdf673c\">\n.flex_column.av-av_three_fifth-6126cab7d8fab8d08143dd2dacdf673c{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_three_fifth-6126cab7d8fab8d08143dd2dacdf673c av_three_fifth  avia-builder-el-20  el_after_av_hr  el_before_av_two_fifth  first flex_column_div av-zero-column-padding  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3\">\n#top .av_textblock_section.av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 .avia_textblock{\ncolor:#ffffff;\n}\n<\/style>\n<section  class='av_textblock_section av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><p style=\"text-align: left;\">Se l&#8217;istanza di SQL Server ha molte basi di dati o hanno un lungo periodo senza revisione, ci possono tornare molte statistiche duplicate. visto che di solito non influisce sulle prestazioni, siamo in grado di concentrarci sulle pi\u00f9 importanti, sia per le sue dimensioni, sia per il numero di righe.<\/p>\n<p>Ora, questo pu\u00f2 essere affrontato in diversi modi. Nel mio caso ho voluto conoscere la dimensione della prima colonna sia in MB come in records. Cio\u00e8, come non mi interessano solo le statistiche, ma anche gli indici, non ho cercato il numero di righe controlate per fare la statistica, ma la colonna. Pertanto, una volta ottenuto quelle statistiche che sembravano duplicate, le ho aggiunte questi dati per poi filtrare le pi\u00f9 importanti.<\/p>\n<\/div><\/section><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_two_fifth-0aa7055fe62c3622faec82866afbaeb2\">\n.flex_column.av-av_two_fifth-0aa7055fe62c3622faec82866afbaeb2{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_two_fifth-0aa7055fe62c3622faec82866afbaeb2 av_two_fifth  avia-builder-el-22  el_after_av_three_fifth  avia-builder-el-last  flex_column_div av-zero-column-padding  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-903b5f287e73542b2a967ffdb92f0f48\">\n.avia-image-container.av-av_image-903b5f287e73542b2a967ffdb92f0f48 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-903b5f287e73542b2a967ffdb92f0f48 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-903b5f287e73542b2a967ffdb92f0f48 av-styling- av-img-linked avia-align-left  avia-builder-el-23  avia-builder-el-no-sibling '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><a href=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img02.png\" data-srcset=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img02.png 695w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img02-300x278.png 300w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img02-450x416.png 450w\" data-sizes=\"(max-width: 695px) 100vw, 695px\" class='avia_image '  aria-label='img02'><img decoding=\"async\" fetchpriority=\"high\" class='wp-image-94166 avia-img-lazy-loading-not-94166 avia_image ' src=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img02-695x630.png\" alt='' title='img02'  height=\"630\" width=\"695\"  itemprop=\"thumbnailUrl\"  \/><\/a><\/div><\/div><\/div><\/div><\/div><\/div><\/div><!-- close content main div --><\/div><div class='av-extra-border-element border-extra-arrow-down'><div class='av-extra-border-outer'><div class='av-extra-border-inner'><\/div><\/div><\/div><\/div><div id='av_section_4'  class='avia-section av-av_section-bb9bdb22c7f9e6bf1d52c155825dc7f7 main_color avia-section-default avia-no-shadow  avia-builder-el-24  el_after_av_section  el_before_av_section  avia-bg-style-scroll container_wrap fullsize'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-full alpha units'><div class='post-entry post-entry-type-page post-entry-106638'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_textblock-3ab19dbd254fedf598017c70d99d0e98\">\n#top .av_textblock_section.av-av_textblock-3ab19dbd254fedf598017c70d99d0e98 .avia_textblock{\ncolor:#0f4589;\n}\n<\/style>\n<section  class='av_textblock_section av-av_textblock-3ab19dbd254fedf598017c70d99d0e98 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><h1 style=\"text-align: center;\">STATISTICHE DUPLICATE<\/h1>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_textblock-3ab19dbd254fedf598017c70d99d0e98\">\n#top .av_textblock_section.av-av_textblock-3ab19dbd254fedf598017c70d99d0e98 .avia_textblock{\ncolor:#0f4589;\n}\n<\/style>\n<section  class='av_textblock_section av-av_textblock-3ab19dbd254fedf598017c70d99d0e98 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><h3 style=\"text-align: center;\">\u00bfperch\u00e8 ci sono statistiche duplicate?<\/h3>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-bbe676ee29fcde2ee286114023beb888\">\n#top .hr.hr-invisible.av-av_hr-bbe676ee29fcde2ee286114023beb888{\nheight:15px;\n}\n<\/style>\n<div  class='hr av-av_hr-bbe676ee29fcde2ee286114023beb888 hr-invisible  avia-builder-el-27  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-av_textblock-d6d4457a071446c54b05855a10e30e07 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><p style=\"text-align: center;\">In genere \u00e8 quando si inizia a lavorare con una tabella, e su questa era abilitata la creazione automatica di statistiche, SQL Server crea statistiche automatiche di colonna per analizzare consulte, e poi si creanno indici. \u00c8 facile trovare tabelle che hanno statistiche in tutte le sue colonne anche se negli aplicativi no si usino queste colonne in ricerche. \u00c8 l\u2019effetto delle prove in produzione dove si analizzano le colonne e SQL Server crea statistiche per consulte che si eseguono una sola volta.<\/p>\n<p style=\"text-align: center;\"><strong>Vediamo un esempio. Queste sono le statistiche automatiche e di indice:<\/strong><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_half-6126cab7d8fab8d08143dd2dacdf673c\">\n.flex_column.av-av_one_half-6126cab7d8fab8d08143dd2dacdf673c{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_one_half-6126cab7d8fab8d08143dd2dacdf673c av_one_half  avia-builder-el-29  el_after_av_textblock  el_before_av_one_half  first flex_column_div av-zero-column-padding  column-top-margin'     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-9e36f4616c908b34c80d6248e9875120\">\n.avia-image-container.av-av_image-9e36f4616c908b34c80d6248e9875120 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-9e36f4616c908b34c80d6248e9875120 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-9e36f4616c908b34c80d6248e9875120 av-styling- av-img-linked avia-align-center  avia-builder-el-30  avia-builder-el-no-sibling '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><a href=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img03.png\" data-srcset=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img03.png 492w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img03-80x80.png 80w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img03-298x300.png 298w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img03-36x36.png 36w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img03-180x180.png 180w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img03-120x120.png 120w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img03-450x453.png 450w\" data-sizes=\"(max-width: 492px) 100vw, 492px\" class='avia_image '  aria-label='img03'><img decoding=\"async\" fetchpriority=\"high\" class='wp-image-94171 avia-img-lazy-loading-not-94171 avia_image ' src=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img03-492x400.png\" alt='' title='img03'  height=\"400\" width=\"492\"  itemprop=\"thumbnailUrl\"  \/><\/a><\/div><\/div><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_half-0aa7055fe62c3622faec82866afbaeb2\">\n.flex_column.av-av_one_half-0aa7055fe62c3622faec82866afbaeb2{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_one_half-0aa7055fe62c3622faec82866afbaeb2 av_one_half  avia-builder-el-31  el_after_av_one_half  el_before_av_hr  flex_column_div av-zero-column-padding  column-top-margin'     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-2708a89fb27861cafa1cd971422624a4\">\n.avia-image-container.av-av_image-2708a89fb27861cafa1cd971422624a4 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-2708a89fb27861cafa1cd971422624a4 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-2708a89fb27861cafa1cd971422624a4 av-styling- av-img-linked avia-align-center  avia-builder-el-32  avia-builder-el-no-sibling '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><a href=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img04.png\" data-srcset=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img04.png 484w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img04-80x80.png 80w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img04-297x300.png 297w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img04-36x36.png 36w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img04-120x120.png 120w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img04-450x455.png 450w\" data-sizes=\"(max-width: 484px) 100vw, 484px\" class='avia_image '  aria-label='img04'><img decoding=\"async\" fetchpriority=\"high\" class='wp-image-94176 avia-img-lazy-loading-not-94176 avia_image ' src=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img04-484x400.png\" alt='' title='img04'  height=\"400\" width=\"484\"  itemprop=\"thumbnailUrl\"  \/><\/a><\/div><\/div><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-fbebcb4fe7f7f93a621d8b6783460008\">\n#top .hr.hr-invisible.av-av_hr-fbebcb4fe7f7f93a621d8b6783460008{\nheight:30px;\n}\n<\/style>\n<div  class='hr av-av_hr-fbebcb4fe7f7f93a621d8b6783460008 hr-invisible  avia-builder-el-33  el_after_av_one_half  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p style=\"text-align: center;\">Se guardiamo bene, una volta aggiornate insieme, sono identiche. Per quello, potremmo togliere le automatiche ed avere un percorso in meno da fare durante la manutenzione. Un\u2019analisi di questo tipo pu\u00f2 evitare di fare la scansione di milioni di linee nella manutenzione della bese di dati.<\/p>\n<\/div><\/section>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_section-b066d809907dd67a48dfd6efd914d5aa\">\n.avia-section.av-av_section-b066d809907dd67a48dfd6efd914d5aa{\nbackground-color:#e0e0e0;\nbackground-image:unset;\n}\n<\/style>\n<div id='av_section_5'  class='avia-section av-av_section-b066d809907dd67a48dfd6efd914d5aa main_color avia-section-default avia-no-shadow  avia-builder-el-35  el_after_av_section  el_before_av_section  avia-bg-style-scroll container_wrap fullsize'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-full alpha units'><div class='post-entry post-entry-type-page post-entry-106638'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_textblock-3ab19dbd254fedf598017c70d99d0e98\">\n#top .av_textblock_section.av-av_textblock-3ab19dbd254fedf598017c70d99d0e98 .avia_textblock{\ncolor:#0f4589;\n}\n<\/style>\n<section  class='av_textblock_section av-av_textblock-3ab19dbd254fedf598017c70d99d0e98 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><h1 style=\"text-align: center;\">ELIMINARE I DUPLICATI<\/h1>\n<\/div><\/section>\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h3 style=\"text-align: center; color: #0f4589;\">Come cercare le statistiche duplicate?<\/h3>\n<p style=\"text-align: center; color: black;\">Quelle precedenti le guardiamo nel Object Explorer:<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_full-6126cab7d8fab8d08143dd2dacdf673c\">\n.flex_column.av-av_one_full-6126cab7d8fab8d08143dd2dacdf673c{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_one_full-6126cab7d8fab8d08143dd2dacdf673c av_one_full  avia-builder-el-38  el_after_av_textblock  el_before_av_hr  first flex_column_div av-zero-column-padding  column-top-margin'     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-e8e34995512e718c86bbde877cd071e0\">\n.avia-image-container.av-av_image-e8e34995512e718c86bbde877cd071e0 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-e8e34995512e718c86bbde877cd071e0 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-e8e34995512e718c86bbde877cd071e0 av-styling- av-img-linked avia-align-center  avia-builder-el-39  avia-builder-el-no-sibling '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><a href=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img05.png\" data-srcset=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img05.png 366w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img05-300x125.png 300w\" data-sizes=\"(max-width: 366px) 100vw, 366px\" class='avia_image '  aria-label='img05'><img decoding=\"async\" fetchpriority=\"high\" class='wp-image-94181 avia-img-lazy-loading-not-94181 avia_image ' src=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img05.png\" alt='' title='img05'  height=\"152\" width=\"366\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img05.png 366w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img05-300x125.png 300w\" sizes=\"(max-width: 366px) 100vw, 366px\" \/><\/a><\/div><\/div><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-fbebcb4fe7f7f93a621d8b6783460008\">\n#top .hr.hr-invisible.av-av_hr-fbebcb4fe7f7f93a621d8b6783460008{\nheight:30px;\n}\n<\/style>\n<div  class='hr av-av_hr-fbebcb4fe7f7f93a621d8b6783460008 hr-invisible  avia-builder-el-40  el_after_av_one_full  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p style=\"text-align: center;\">Vediamo che la consulta ci da sia il nome, come l\u2019identificatore nel campo decimale e esadecimale. Per le statistiche automatiche, quel identificatore esadecimale si trova nel nome della statistica e cos\u00ec lo possiamo trovare rapidamente. Nel esempio, il campo IDTASK \u00e8 il secondo e troviamo il duplicato subito.<\/p>\n<p style=\"text-align: center;\">In altre occasioni bisogna analizzare ogni statistica per trovare il duplicato. Per esempio nel caso degli indici &lt;&lt;duplicati&gt;&gt;:<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-fbebcb4fe7f7f93a621d8b6783460008\">\n#top .hr.hr-invisible.av-av_hr-fbebcb4fe7f7f93a621d8b6783460008{\nheight:30px;\n}\n<\/style>\n<div  class='hr av-av_hr-fbebcb4fe7f7f93a621d8b6783460008 hr-invisible  avia-builder-el-42  el_after_av_textblock  el_before_av_image '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-eb612118f8fe5d9d08428f5f1440359f\">\n.avia-image-container.av-av_image-eb612118f8fe5d9d08428f5f1440359f img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-eb612118f8fe5d9d08428f5f1440359f .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-eb612118f8fe5d9d08428f5f1440359f av-styling- av-img-linked avia-align-center  avia-builder-el-43  el_after_av_hr  el_before_av_hr '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><a href=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img06.png\" data-srcset=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img06.png 331w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img06-300x167.png 300w\" data-sizes=\"(max-width: 331px) 100vw, 331px\" class='avia_image '  aria-label='img06'><img decoding=\"async\" fetchpriority=\"high\" class='wp-image-94186 avia-img-lazy-loading-not-94186 avia_image ' src=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img06.png\" alt='' title='img06'  height=\"184\" width=\"331\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img06.png 331w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2016\/12\/img06-300x167.png 300w\" sizes=\"(max-width: 331px) 100vw, 331px\" \/><\/a><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-fbebcb4fe7f7f93a621d8b6783460008\">\n#top .hr.hr-invisible.av-av_hr-fbebcb4fe7f7f93a621d8b6783460008{\nheight:30px;\n}\n<\/style>\n<div  class='hr av-av_hr-fbebcb4fe7f7f93a621d8b6783460008 hr-invisible  avia-builder-el-44  el_after_av_image  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p style=\"text-align: center;\">In questo caso abbiamo che ci sono tre statistiche che iniziano per il campo ATTRIBUTE_ID, quindi ci offre un aiuto aggiuntivo per questo tipo di analisi: C\u2019\u00e8 qualche indice superfluo? Per quello ricorreremo all\u2019analisi standar del uso degl\u2019indici e elimineremo quei indici (quello che fa sparire la statistica) che si aggiornano troppo e si usano poco. In oltre ocasioni vedremo che, anche se ce una posibilit\u00e8 superflua, incluso che un indici copra un\u2019altro, tutti si stanno usando per accelerare le consulte specifiche e quindi sono necessarie. In questo caso \u00e8 meglio lasciarli.<\/p>\n<\/div><\/section>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_section-8c5fa7eb31d852e0f04a88a5b4fc4a66\">\n.avia-section.av-av_section-8c5fa7eb31d852e0f04a88a5b4fc4a66{\nbackground-color:#ed9807;\nbackground-image:unset;\n}\n<\/style>\n<div id='av_section_6'  class='avia-section av-av_section-8c5fa7eb31d852e0f04a88a5b4fc4a66 main_color avia-section-default avia-no-shadow  avia-builder-el-46  el_after_av_section  el_before_av_section  avia-bg-style-scroll container_wrap fullsize'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-full alpha units'><div class='post-entry post-entry-type-page post-entry-106638'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3\">\n#top .av_textblock_section.av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 .avia_textblock{\ncolor:#ffffff;\n}\n<\/style>\n<section  class='av_textblock_section av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><h3 style=\"text-align: center;\">sys.stats<\/h3>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-616cd310f4c6bf63bbd1f033802c1165\">\n#top .hr.hr-invisible.av-av_hr-616cd310f4c6bf63bbd1f033802c1165{\nheight:20px;\n}\n<\/style>\n<div  class='hr av-av_hr-616cd310f4c6bf63bbd1f033802c1165 hr-invisible  avia-builder-el-48  el_after_av_textblock  el_before_av_iconlist '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_iconlist-8e60e95cc2ba784626add97ad7c8d80a\">\n#top .avia-icon-list-container.av-av_iconlist-8e60e95cc2ba784626add97ad7c8d80a .iconlist_icon{\nbackground-color:#ed9807;\n}\n#top #wrap_all .avia-icon-list-container.av-av_iconlist-8e60e95cc2ba784626add97ad7c8d80a .av_iconlist_title{\ncolor:#ffffff;\n}\n.avia-icon-list-container.av-av_iconlist-8e60e95cc2ba784626add97ad7c8d80a .iconlist_content{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-icon-list-container av-av_iconlist-8e60e95cc2ba784626add97ad7c8d80a  avia-builder-el-49  el_after_av_hr  el_before_av_textblock '><ul class='avia-icon-list avia_animate_when_almost_visible avia-icon-list-left av-iconlist-big av-av_iconlist-8e60e95cc2ba784626add97ad7c8d80a avia-iconlist-animate'>\n<li><div class='iconlist_icon av-av_iconlist_item-c6391a91ef31fbe60cc63c7f0b55951e avia-font-entypo-fontello avia-iconfont avia-font-entypo-fontello'><span class='av-icon-char' data-av_icon='\ue812' data-av_iconfont='entypo-fontello' aria-hidden=\"true\"><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\" aria-label=\"Icona: \"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p>Come nota aggiuntiva, la tabella precedente ci da pi\u00f9 dati che in certe ocasioni ci pu\u00f2 aiutare con l\u2019analisi delle basi di dati, come pu\u00f2 essere se la statistica \u00e8 una creazione automatica (campo auto_created), e se \u00e8 creata manualmente (user_created) o si precede di un indice (entrambi campi sono zero). Ci potrebbe servire per collegare le statistiche con il suo indice.<br \/>\nAnche se \u00e8 una statistica filtrata. In questo caso no le ho voluto togliere perch\u00e8 volevo fare un\u2019analisi aggiuntivo degli indici e volevo escluderli una volta controlati.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<\/ul><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3\">\n#top .av_textblock_section.av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 .avia_textblock{\ncolor:#ffffff;\n}\n<\/style>\n<section  class='av_textblock_section av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><h3 style=\"text-align: center;\">stats_column_id<\/h3>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-616cd310f4c6bf63bbd1f033802c1165\">\n#top .hr.hr-invisible.av-av_hr-616cd310f4c6bf63bbd1f033802c1165{\nheight:20px;\n}\n<\/style>\n<div  class='hr av-av_hr-616cd310f4c6bf63bbd1f033802c1165 hr-invisible  avia-builder-el-51  el_after_av_textblock  el_before_av_iconlist '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_iconlist-8e60e95cc2ba784626add97ad7c8d80a\">\n#top .avia-icon-list-container.av-av_iconlist-8e60e95cc2ba784626add97ad7c8d80a .iconlist_icon{\nbackground-color:#ed9807;\n}\n#top #wrap_all .avia-icon-list-container.av-av_iconlist-8e60e95cc2ba784626add97ad7c8d80a .av_iconlist_title{\ncolor:#ffffff;\n}\n.avia-icon-list-container.av-av_iconlist-8e60e95cc2ba784626add97ad7c8d80a .iconlist_content{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-icon-list-container av-av_iconlist-8e60e95cc2ba784626add97ad7c8d80a  avia-builder-el-52  el_after_av_hr  el_before_av_image '><ul class='avia-icon-list avia_animate_when_almost_visible avia-icon-list-left av-iconlist-big av-av_iconlist-8e60e95cc2ba784626add97ad7c8d80a avia-iconlist-animate'>\n<li><div class='iconlist_icon av-av_iconlist_item-c6391a91ef31fbe60cc63c7f0b55951e avia-font-entypo-fontello avia-iconfont avia-font-entypo-fontello'><span class='av-icon-char' data-av_icon='\ue812' data-av_iconfont='entypo-fontello' aria-hidden=\"true\"><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\" aria-label=\"Icona: \"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><section class=\"av_textblock_section \">\n<div class=\"avia_textblock \">\n<p>In fine, il codice esposto non cotempla un bug che esiste alla vista di sys_stats_columns e che in ocasioni fa che tale campo ci dia l\u2019ordine reale dei campi dentro le statistiche e bisogna rocorrere alle viste per indice per sapere tale ordine. Vediamo un esempio:<\/p>\n<\/div>\n<\/section>\n<section class=\"av_textblock_section \">\n<div class=\"avia_textblock \"><\/div>\n<\/section>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<\/ul><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-8824d8484cd3cbbf21ed09990b48ab9d\">\n.avia-image-container.av-av_image-8824d8484cd3cbbf21ed09990b48ab9d img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-8824d8484cd3cbbf21ed09990b48ab9d .av-caption-image-overlay-bg{\nopacity:0.4;\nbackground-color:#000000;\n}\n.avia-image-container.av-av_image-8824d8484cd3cbbf21ed09990b48ab9d .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-8824d8484cd3cbbf21ed09990b48ab9d av-styling- av-img-linked avia-align-center  avia-builder-el-53  el_after_av_iconlist  el_before_av_hr  noHover av-overlay-hover-deactivate'   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><a href=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/yk.png\" data-srcset=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/yk.png 667w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/yk-300x94.png 300w, https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/yk-450x142.png 450w\" data-sizes=\"(max-width: 667px) 100vw, 667px\" class='avia_image '  aria-label='stats_column_id'><div class=\"av-image-caption-overlay\"><div class=\"av-caption-image-overlay-bg\"><\/div><div class=\"av-image-caption-overlay-position\"><div class=\"av-image-caption-overlay-center\"><p>Stats_column_id<\/p>\n<\/div><\/div><\/div><img decoding=\"async\" fetchpriority=\"high\" class='wp-image-122918 avia-img-lazy-loading-not-122918 avia_image ' src=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/yk-495x210.png\" alt='' title='stats_column_id'  height=\"210\" width=\"495\"  itemprop=\"thumbnailUrl\"  \/><\/a><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-fbebcb4fe7f7f93a621d8b6783460008\">\n#top .hr.hr-invisible.av-av_hr-fbebcb4fe7f7f93a621d8b6783460008{\nheight:30px;\n}\n<\/style>\n<div  class='hr av-av_hr-fbebcb4fe7f7f93a621d8b6783460008 hr-invisible  avia-builder-el-54  el_after_av_image  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3\">\n#top .av_textblock_section.av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 .avia_textblock{\ncolor:#ffffff;\n}\n<\/style>\n<section  class='av_textblock_section av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><p style=\"text-align: center;\">Se guardiamo bene, l\u2019ordine delle colonne nella vista della statistica (stats_column_id) \u00e8 molto diverso a quello reale che ci indica la vista dell\u2019indice (key_ordina). Quindi, questa consulta dovrebbe essere migliorata affinch\u00e8, se una statistica d\u2019indice, trovasse il primo campo dell\u2019indice invece di quello della statistica. Ma questa implicazione la lasciamo come compito.<\/p>\n<\/div><\/section>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_section-fcd50882516e9712fce541cc540b184f\">\n.avia-section.av-av_section-fcd50882516e9712fce541cc540b184f{\nbackground-color:#0f4589;\nbackground-image:unset;\n}\n<\/style>\n<div id='av_section_7'  class='avia-section av-av_section-fcd50882516e9712fce541cc540b184f main_color avia-section-default avia-no-shadow  avia-builder-el-56  el_after_av_section  el_before_av_section  avia-bg-style-scroll container_wrap fullsize'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-full alpha units'><div class='post-entry post-entry-type-page post-entry-106638'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3\">\n#top .av_textblock_section.av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 .avia_textblock{\ncolor:#ffffff;\n}\n<\/style>\n<section  class='av_textblock_section av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><h1 style=\"text-align: center;\">CONCLUSI\u00d3N<\/h1>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-fbebcb4fe7f7f93a621d8b6783460008\">\n#top .hr.hr-invisible.av-av_hr-fbebcb4fe7f7f93a621d8b6783460008{\nheight:30px;\n}\n<\/style>\n<div  class='hr av-av_hr-fbebcb4fe7f7f93a621d8b6783460008 hr-invisible  avia-builder-el-58  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3\">\n#top .av_textblock_section.av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 .avia_textblock{\ncolor:#ffffff;\n}\n<\/style>\n<section  class='av_textblock_section av-av_textblock-dd2387397296c1a314b0b5f4a3f918a3 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock av_inherit_color'  itemprop=\"text\" ><p style=\"text-align: center;\">Anche se non \u00e8 necessario l\u2019analisi delle statistiche duplicate, se usiamo i filtri adeguati ci possono indicare quelle che migliorano la manutenzione come quei indici que possiamo eliminare.<\/p>\n<\/div><\/section>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='av_section_8'  class='avia-section av-av_section-4ab2c50611e8bc0ab9af19846c400691 main_color avia-section-default avia-no-shadow  avia-builder-el-60  el_after_av_section  el_before_av_section  avia-bg-style-scroll container_wrap fullsize'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-full alpha units'><div class='post-entry post-entry-type-page post-entry-106638'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_fourth-6126cab7d8fab8d08143dd2dacdf673c\">\n.flex_column.av-av_one_fourth-6126cab7d8fab8d08143dd2dacdf673c{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_one_fourth-6126cab7d8fab8d08143dd2dacdf673c av_one_fourth first flex_column_div av-zero-column-padding  '     ><div  class='avia-button-wrap av-av_button-e4320a7478aec51b671ce0dfe05a425a-wrap avia-button-center '><a href='https:\/\/www.danysoft.com\/it\/prodottix\/news-prodotti\/'  class='avia-button av-av_button-e4320a7478aec51b671ce0dfe05a425a av-link-btn avia-icon_select-yes-left-icon avia-size-x-large avia-position-center av-icon-on-hover avia-color-theme-color'  target=\"_blank\"  rel=\"noopener noreferrer\"  aria-label=\"Noticias\"><span class='avia_button_icon avia_button_icon_left avia-iconfont avia-font-entypo-fontello' data-av_icon='\ue84d' data-av_iconfont='entypo-fontello' ><\/span><span class='avia_iconbox_title' >Noticias<\/span><\/a><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_fourth-0aa7055fe62c3622faec82866afbaeb2\">\n.flex_column.av-av_one_fourth-0aa7055fe62c3622faec82866afbaeb2{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_one_fourth-0aa7055fe62c3622faec82866afbaeb2 av_one_fourth flex_column_div av-zero-column-padding  '     ><div  class='avia-button-wrap av-av_button-3ecbb9f9439cd6fec953fd1ede490b40-wrap avia-button-center '><a href='https:\/\/danysoft.com\/comunita\/eventi\/'  class='avia-button av-av_button-3ecbb9f9439cd6fec953fd1ede490b40 av-link-btn avia-icon_select-yes-left-icon avia-size-x-large avia-position-center av-icon-on-hover avia-color-theme-color'  target=\"_blank\"  rel=\"noopener noreferrer\"  aria-label=\"Eventi\"><span class='avia_button_icon avia_button_icon_left avia-iconfont avia-font-entypo-fontello' data-av_icon='\ue80b' data-av_iconfont='entypo-fontello' ><\/span><span class='avia_iconbox_title' >Eventi<\/span><\/a><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_fourth-0aa7055fe62c3622faec82866afbaeb2\">\n.flex_column.av-av_one_fourth-0aa7055fe62c3622faec82866afbaeb2{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_one_fourth-0aa7055fe62c3622faec82866afbaeb2 av_one_fourth flex_column_div av-zero-column-padding  '     ><div  class='avia-button-wrap av-av_button-0d55b643800f87da366f8426889d30d6-wrap avia-button-center '><a href='https:\/\/danysoft.com\/comunita\/video\/'  class='avia-button av-av_button-0d55b643800f87da366f8426889d30d6 av-link-btn avia-icon_select-yes-left-icon avia-size-x-large avia-position-center av-icon-on-hover avia-color-theme-color'  target=\"_blank\"  rel=\"noopener noreferrer\"  aria-label=\"Video\"><span class='avia_button_icon avia_button_icon_left avia-iconfont avia-font-entypo-fontello' data-av_icon='\ue80d' data-av_iconfont='entypo-fontello' ><\/span><span class='avia_iconbox_title' >Video<\/span><\/a><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_fourth-0aa7055fe62c3622faec82866afbaeb2\">\n.flex_column.av-av_one_fourth-0aa7055fe62c3622faec82866afbaeb2{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-av_one_fourth-0aa7055fe62c3622faec82866afbaeb2 av_one_fourth flex_column_div av-zero-column-padding  '     ><div  class='avia-button-wrap av-av_button-43f1d80acda4691f9305a638748625a0-wrap avia-button-center '><a href='https:\/\/danysoft.com\/danysoft\/contatto\/'  class='avia-button av-av_button-43f1d80acda4691f9305a638748625a0 av-link-btn avia-icon_select-yes-left-icon avia-size-x-large avia-position-center av-icon-on-hover avia-color-theme-color'  target=\"_blank\"  rel=\"noopener noreferrer\"  aria-label=\"Contatto\"><span class='avia_button_icon avia_button_icon_left avia-iconfont avia-font-entypo-fontello' data-av_icon='\ue854' data-av_iconfont='entypo-fontello' ><\/span><span class='avia_iconbox_title' >Contatto<\/span><\/a><\/div><\/div><\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='av_section_9'  class='avia-section av-av_section-4ab2c50611e8bc0ab9af19846c400691 main_color avia-section-default avia-no-shadow avia-bg-style-scroll container_wrap fullsize'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-full alpha units'><div class='post-entry post-entry-type-page post-entry-106638'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_full-ea6a225f749ff05cc4be02918c385eef\">\n.flex_column.av-av_one_full-ea6a225f749ff05cc4be02918c385eef{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\nbackground-color:#ffffff;\n}\n<\/style>\n<div  class='flex_column av-av_one_full-ea6a225f749ff05cc4be02918c385eef av_one_full  avia-builder-el-61  avia-builder-el-no-sibling  first flex_column_div av-zero-column-padding  '     ><p><div  class='av-social-sharing-box av-av_social_share-f11c895a16b70a46bb457368dc342ca2 av-social-sharing-box-minimal  avia-builder-el-62  el_before_av_comments_list  avia-builder-el-first  av-social-sharing-box-fullwidth'><div class=\"av-share-box\"><ul class=\"av-share-box-list noLightbox\"><li class='av-share-link av-social-link-facebook avia_social_iconfont' ><a target=\"_blank\" aria-label=\"Condividi su Facebook\" href='https:\/\/www.facebook.com\/sharer.php?u=https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/&#038;t=Statistiche%20Duplicate' data-av_icon='\ue8f3' data-av_iconfont='entypo-fontello'  title='' data-avia-related-tooltip='Condividi su Facebook'><span class='avia_hidden_link_text'>Condividi su Facebook<\/span><\/a><\/li><li class='av-share-link av-social-link-pinterest avia_social_iconfont' ><a target=\"_blank\" aria-label=\"Condividi su Pinterest\" href='https:\/\/pinterest.com\/pin\/create\/button\/?url=https%3A%2F%2Fwww.danysoft.com%2Fit%2Fstatistiche-duplicate%2F&#038;description=Statistiche%20Duplicate&#038;media=https%3A%2F%2Fwww.danysoft.com%2Fwp-content%2Fuploads%2F2017%2F08%2Fstormtrooper-705x235.jpg' data-av_icon='\ue8f8' data-av_iconfont='entypo-fontello'  title='' data-avia-related-tooltip='Condividi su Pinterest'><span class='avia_hidden_link_text'>Condividi su Pinterest<\/span><\/a><\/li><li class='av-share-link av-social-link-linkedin avia_social_iconfont' ><a target=\"_blank\" aria-label=\"Condividi su LinkedIn\" href='https:\/\/linkedin.com\/shareArticle?mini=true&#038;title=Statistiche%20Duplicate&#038;url=https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/' data-av_icon='\ue8fc' data-av_iconfont='entypo-fontello'  title='' data-avia-related-tooltip='Condividi su LinkedIn'><span class='avia_hidden_link_text'>Condividi su LinkedIn<\/span><\/a><\/li><li class='av-share-link av-social-link-reddit avia_social_iconfont' ><a target=\"_blank\" aria-label=\"Condividi su Reddit\" href='https:\/\/reddit.com\/submit?url=https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/&#038;title=Statistiche%20Duplicate' data-av_icon='\ue927' data-av_iconfont='entypo-fontello'  title='' data-avia-related-tooltip='Condividi su Reddit'><span class='avia_hidden_link_text'>Condividi su Reddit<\/span><\/a><\/li><li class='av-share-link av-social-link-mail avia_social_iconfont' ><a  aria-label=\"Condividi attraverso Mail\" href='mailto:?subject=Statistiche%20Duplicate&#038;body=https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/' data-av_icon='\ue805' data-av_iconfont='entypo-fontello'  title='' data-avia-related-tooltip='Condividi attraverso Mail'><span class='avia_hidden_link_text'>Condividi attraverso Mail<\/span><\/a><\/li><\/ul><\/div><\/div><br \/>\n<div  class='av-buildercomment av-av_comments_list-88ce68e426f11248fa394058a3de040f  av-blog-meta-author-disabled av-blog-meta-category-disabled av-blog-meta-html-info-disabled'><\/div><\/p><\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>Cosa fare per cercarle e como aggire quando le troviamo<\/p>\n","protected":false},"author":1,"featured_media":105882,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[3425],"tags":[5516,5515,5517,5514],"class_list":["post-106638","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articoli","tag-eliminare-i-duplicati","tag-statistiche-duplicate","tag-stats_column_id","tag-sys-stats"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Statistiche Duplicate | Cosa fare per cercarle e como aggire<\/title>\n<meta name=\"description\" content=\"Anche se l\u2019esistenza di statistiche doppie non genera problemi perch\u00e9 occupano poco spazio e non affeta al rendimento, ci pu\u00f2 essere utile controlare [...]\" \/>\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.danysoft.com\/it\/statistiche-duplicate\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Statistiche Duplicate | Cosa fare per cercarle e como aggire\" \/>\n<meta property=\"og:description\" content=\"Anche se l\u2019esistenza di statistiche doppie non genera problemi perch\u00e9 occupano poco spazio e non affeta al rendimento, ci pu\u00f2 essere utile controlare [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/\" \/>\n<meta property=\"og:site_name\" content=\"Danysoft\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/danysoft\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-17T15:08:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-17T15:09:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/stormtrooper.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1500\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Administrador\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@danysoft_es\" \/>\n<meta name=\"twitter:site\" content=\"@danysoft_es\" \/>\n<meta name=\"twitter:label1\" content=\"Scritto da\" \/>\n\t<meta name=\"twitter:data1\" content=\"Administrador\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data2\" content=\"22 minuti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/statistiche-duplicate\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/statistiche-duplicate\\\/\"},\"author\":{\"name\":\"Administrador\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/#\\\/schema\\\/person\\\/405a8d48d450729ff679467017ba0e23\"},\"headline\":\"Statistiche Duplicate\",\"datePublished\":\"2017-08-17T15:08:24+00:00\",\"dateModified\":\"2017-08-17T15:09:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/statistiche-duplicate\\\/\"},\"wordCount\":3555,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/statistiche-duplicate\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.danysoft.com\\\/wp-content\\\/uploads\\\/2017\\\/08\\\/stormtrooper.jpg\",\"keywords\":[\"ELIMINARE I DUPLICATI\",\"Statistiche Duplicate\",\"STATS_COLUMN_ID\",\"sys.stats\"],\"articleSection\":[\"Articoli\"],\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.danysoft.com\\\/it\\\/statistiche-duplicate\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/statistiche-duplicate\\\/\",\"url\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/statistiche-duplicate\\\/\",\"name\":\"Statistiche Duplicate | Cosa fare per cercarle e como aggire\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/statistiche-duplicate\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/statistiche-duplicate\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.danysoft.com\\\/wp-content\\\/uploads\\\/2017\\\/08\\\/stormtrooper.jpg\",\"datePublished\":\"2017-08-17T15:08:24+00:00\",\"dateModified\":\"2017-08-17T15:09:29+00:00\",\"description\":\"Anche se l\u2019esistenza di statistiche doppie non genera problemi perch\u00e9 occupano poco spazio e non affeta al rendimento, ci pu\u00f2 essere utile controlare [...]\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/statistiche-duplicate\\\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.danysoft.com\\\/it\\\/statistiche-duplicate\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/statistiche-duplicate\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.danysoft.com\\\/wp-content\\\/uploads\\\/2017\\\/08\\\/stormtrooper.jpg\",\"contentUrl\":\"https:\\\/\\\/www.danysoft.com\\\/wp-content\\\/uploads\\\/2017\\\/08\\\/stormtrooper.jpg\",\"width\":1500,\"height\":500},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/statistiche-duplicate\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/home-2-2-2\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistiche Duplicate\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/#website\",\"url\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/\",\"name\":\"Danysoft\",\"description\":\"Licencias software y servicios de formaci\u00f3n y consultor\u00eda necesarios para su correcto uso\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/#organization\",\"name\":\"Danysoft\",\"url\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.danysoft.com\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/danysoft.png\",\"contentUrl\":\"https:\\\/\\\/www.danysoft.com\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/danysoft.png\",\"width\":1001,\"height\":309,\"caption\":\"Danysoft\"},\"image\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"http:\\\/\\\/www.facebook.com\\\/danysoft\",\"https:\\\/\\\/x.com\\\/danysoft_es\",\"https:\\\/\\\/es.linkedin.com\\\/company\\\/danysoft\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/danysoftech\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/it\\\/#\\\/schema\\\/person\\\/405a8d48d450729ff679467017ba0e23\",\"name\":\"Administrador\",\"sameAs\":[\"https:\\\/\\\/danysoft.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Statistiche Duplicate | Cosa fare per cercarle e como aggire","description":"Anche se l\u2019esistenza di statistiche doppie non genera problemi perch\u00e9 occupano poco spazio e non affeta al rendimento, ci pu\u00f2 essere utile controlare [...]","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.danysoft.com\/it\/statistiche-duplicate\/","og_locale":"it_IT","og_type":"article","og_title":"Statistiche Duplicate | Cosa fare per cercarle e como aggire","og_description":"Anche se l\u2019esistenza di statistiche doppie non genera problemi perch\u00e9 occupano poco spazio e non affeta al rendimento, ci pu\u00f2 essere utile controlare [...]","og_url":"https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/","og_site_name":"Danysoft","article_publisher":"http:\/\/www.facebook.com\/danysoft","article_published_time":"2017-08-17T15:08:24+00:00","article_modified_time":"2017-08-17T15:09:29+00:00","og_image":[{"width":1500,"height":500,"url":"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/stormtrooper.jpg","type":"image\/jpeg"}],"author":"Administrador","twitter_card":"summary_large_image","twitter_creator":"@danysoft_es","twitter_site":"@danysoft_es","twitter_misc":{"Scritto da":"Administrador","Tempo di lettura stimato":"22 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/#article","isPartOf":{"@id":"https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/"},"author":{"name":"Administrador","@id":"https:\/\/www.danysoft.com\/it\/#\/schema\/person\/405a8d48d450729ff679467017ba0e23"},"headline":"Statistiche Duplicate","datePublished":"2017-08-17T15:08:24+00:00","dateModified":"2017-08-17T15:09:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/"},"wordCount":3555,"commentCount":0,"publisher":{"@id":"https:\/\/www.danysoft.com\/it\/#organization"},"image":{"@id":"https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/#primaryimage"},"thumbnailUrl":"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/stormtrooper.jpg","keywords":["ELIMINARE I DUPLICATI","Statistiche Duplicate","STATS_COLUMN_ID","sys.stats"],"articleSection":["Articoli"],"inLanguage":"it-IT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/","url":"https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/","name":"Statistiche Duplicate | Cosa fare per cercarle e como aggire","isPartOf":{"@id":"https:\/\/www.danysoft.com\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/#primaryimage"},"image":{"@id":"https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/#primaryimage"},"thumbnailUrl":"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/stormtrooper.jpg","datePublished":"2017-08-17T15:08:24+00:00","dateModified":"2017-08-17T15:09:29+00:00","description":"Anche se l\u2019esistenza di statistiche doppie non genera problemi perch\u00e9 occupano poco spazio e non affeta al rendimento, ci pu\u00f2 essere utile controlare [...]","breadcrumb":{"@id":"https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/#primaryimage","url":"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/stormtrooper.jpg","contentUrl":"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/stormtrooper.jpg","width":1500,"height":500},{"@type":"BreadcrumbList","@id":"https:\/\/www.danysoft.com\/it\/statistiche-duplicate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.danysoft.com\/it\/home-2-2-2\/"},{"@type":"ListItem","position":2,"name":"Statistiche Duplicate"}]},{"@type":"WebSite","@id":"https:\/\/www.danysoft.com\/it\/#website","url":"https:\/\/www.danysoft.com\/it\/","name":"Danysoft","description":"Licencias software y servicios de formaci\u00f3n y consultor\u00eda necesarios para su correcto uso","publisher":{"@id":"https:\/\/www.danysoft.com\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.danysoft.com\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/www.danysoft.com\/it\/#organization","name":"Danysoft","url":"https:\/\/www.danysoft.com\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/www.danysoft.com\/it\/#\/schema\/logo\/image\/","url":"https:\/\/www.danysoft.com\/wp-content\/uploads\/2018\/07\/danysoft.png","contentUrl":"https:\/\/www.danysoft.com\/wp-content\/uploads\/2018\/07\/danysoft.png","width":1001,"height":309,"caption":"Danysoft"},"image":{"@id":"https:\/\/www.danysoft.com\/it\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/danysoft","https:\/\/x.com\/danysoft_es","https:\/\/es.linkedin.com\/company\/danysoft","https:\/\/www.youtube.com\/user\/danysoftech"]},{"@type":"Person","@id":"https:\/\/www.danysoft.com\/it\/#\/schema\/person\/405a8d48d450729ff679467017ba0e23","name":"Administrador","sameAs":["https:\/\/danysoft.com"]}]}},"_links":{"self":[{"href":"https:\/\/www.danysoft.com\/it\/wp-json\/wp\/v2\/posts\/106638","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.danysoft.com\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.danysoft.com\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.danysoft.com\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.danysoft.com\/it\/wp-json\/wp\/v2\/comments?post=106638"}],"version-history":[{"count":0,"href":"https:\/\/www.danysoft.com\/it\/wp-json\/wp\/v2\/posts\/106638\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.danysoft.com\/it\/wp-json\/wp\/v2\/media\/105882"}],"wp:attachment":[{"href":"https:\/\/www.danysoft.com\/it\/wp-json\/wp\/v2\/media?parent=106638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.danysoft.com\/it\/wp-json\/wp\/v2\/categories?post=106638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.danysoft.com\/it\/wp-json\/wp\/v2\/tags?post=106638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}