{"id":106607,"date":"2017-08-17T16:54:19","date_gmt":"2017-08-17T14:54:19","guid":{"rendered":"http:\/\/www.danysoft.com\/?p=106607\/"},"modified":"2017-08-17T16:55:31","modified_gmt":"2017-08-17T14:55:31","slug":"estatisticas-duplicadas","status":"publish","type":"post","link":"https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/","title":{"rendered":"Estat\u00edsticas Duplicadas"},"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 sidebar_right'  ><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\" >Estat\u00edsticas Duplicadas<\/h2><div class='avia-caption-content av_inherit_color'  itemprop=\"description\" ><p>Que fazer para as procurar e como atuar quando as encontramos<\/p>\n<\/div><\/div><\/div><\/div><\/div><\/div><img decoding=\"async\" fetchpriority=\"high\" class=\"wp-image-122916 avia-img-lazy-loading-not-122916\"  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 sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-106607'><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;\">A EXISTENCIA DE ESTATISTICAS DUPLICADA<\/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;\">Introdu\u00e7\u00e3o<\/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;\">Ainda que a exist\u00eancia de estat\u00edsticas duplicadas n\u00e3o costuma gerar problema porque ocupam pouco espa\u00e7o e n\u00e3o afetam muito o rendimento, pode resultar-nos \u00fatil revisar as mais grandes para as eliminar e diminuir o tempo de manuten\u00e7\u00e3o, e porque nos podem dar pistas de \u00edndices duplicados.<\/p>\n<\/div><\/section>\n\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 sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-106607'><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;\">PESQUISA DE DUPLICADOS<\/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;\">Para pesquisar que estat\u00edsticas ou \u00edndices est\u00e3o duplicados, baseamos-mos no primeiro campo. <strong>Isto porque, a\/ as estat\u00edsticas autom\u00e1ticas s\u00e3o sobre um mesmo campo;<\/strong> b\/ as estat\u00edsticas de um usu\u00e1rio podem ir sobre v\u00e1rios campos, devemos analis\u00e1-los para ver se um cobre o outro ou se os dois s\u00e3o necess\u00e1rios. Portanto, n\u00e3o vamos \u00e0 procura de coincid\u00eancias exatas, sen\u00e3o indicadores de que podem existir estat\u00edsticas ou \u00edndices a mais, e que <strong>melhorar\u00e1 o rendimento elimin\u00e1-los. <\/strong><\/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;\">Para isso, por cada base de dados procuramos em todas as tabelas (sys.tables e sys.schemas) todas as estat\u00edsticas (sys.stats) e o primeiro campo segundo a ordem da estat\u00edstica (sys.stats_columns), al\u00e9m do nome e largura da dita coluna (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>A largura \u00e9 algo informativo, pois outra coisa que podemos fazer \u00e9 eliminar estat\u00edsticas de campos muitos largos pois geralmente n\u00e3o se usam nas consultas. Quer dizer, num campo grande, <strong>costuma-se usar LIKE<\/strong> para procurar em qualquer parte o dito campo e as estat\u00edsticas geralmente n\u00e3o ajudam nesse caso.<\/p>\n<p>Se agrupamos pelo indentificador do objeto e da coluna, vamos ter aquelas estat\u00edsticas que pod\u00edamos analisar.<\/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-fa8fde5bb554920996cc54c61d852051\">\n.avia-image-container.av-av_image-fa8fde5bb554920996cc54c61d852051 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-fa8fde5bb554920996cc54c61d852051 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-fa8fde5bb554920996cc54c61d852051 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-123040 avia-img-lazy-loading-not-123040 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>\n\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-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 sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-106607'><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;\">DATOS ADICIONALES<\/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 a instancia do Servidor SQL Server tem muitas bases de dados ou as bases de dados levam tempo sem se revisar, podem-nos devolver muitas estat\u00edsticas duplicadas. Dado que n\u00e3o costumam afetar o rendimento, podemos centrar-nos nas mais importantes, bem seja pelo seu tamanho, bem seja pelo n\u00famero de filas.<\/p>\n<p>Agora bem, isto podemos focar de v\u00e1rias maneiras. No meu caso, interessava-me saber o tamanho da primeira coluna tanto em MB como em recordes. \u00c9 dizer, como n\u00e3o me interessavam exclusivamente as estat\u00edsticas, nem o tamanho da dita coluna, sen\u00e3o da coluna. Portanto, uma vez conseguidas que estat\u00edsticas apareciam duplicadas, adicionei-lhes estes dados para logo filtrar as mais importantes.<\/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-5440569d0972816a87e9df91f843ebad\">\n.avia-image-container.av-av_image-5440569d0972816a87e9df91f843ebad img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-5440569d0972816a87e9df91f843ebad .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-5440569d0972816a87e9df91f843ebad 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-94168 avia-img-lazy-loading-not-94168 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>\n\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_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 sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-106607'><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;\">ESTATISTICAS DUPLICADAS<\/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;\">Por que h\u00e1 estat\u00edsticas \u201cduplicadas\u201d?<\/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;\">Geralmente \u00e9 porque se come\u00e7ou a trabalhar com uma tabela, estava habilitada a cria\u00e7\u00e3o autom\u00e1tica de estat\u00edsticas, SQL Server cria estat\u00edsticas autom\u00e1ticas de coluna para realizar consultas e logo se criam os \u00edndices. \u00c9 f\u00e1cil encontrar tabelas que t\u00eam estat\u00edsticas em todas as suas colunas, ainda que nas aplica\u00e7\u00f5es n\u00e3o se usem as ditas colunas em buscas ou uni\u00f5es. \u00c9 o efeito das provas em produ\u00e7\u00e3o onde \u00e0s vezes se analisam as colunas e o SQL Server cria estat\u00edsticas para consultas que se executam uma s\u00f3 vez. Ditas estat\u00edsticas s\u00e3o id\u00eanticas se se atualizaram ao mesmo tempo. De outra maneira, os duplicados podem gerar estat\u00edsticas diferentes para os mesmos dados, que, sem a manuten\u00e7\u00e3o adequada, podem fazer que o optimizador de consultas gere um plano incorreto.<\/p>\n<p style=\"text-align: center;\"><strong>Vejamos um exemplo. Estas s\u00e3o as estat\u00edsticas autom\u00e1ticas e de \u00edndice:<\/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-db911f058519769eaec05cc34360cf0a\">\n.avia-image-container.av-av_image-db911f058519769eaec05cc34360cf0a img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-db911f058519769eaec05cc34360cf0a .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-db911f058519769eaec05cc34360cf0a 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-94173 avia-img-lazy-loading-not-94173 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-3a887e9611d14eaef476226c0db08268\">\n.avia-image-container.av-av_image-3a887e9611d14eaef476226c0db08268 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-3a887e9611d14eaef476226c0db08268 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-3a887e9611d14eaef476226c0db08268 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-94178 avia-img-lazy-loading-not-94178 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 nos focamos, ao se haver atualizado em simult\u00e2neo, s\u00e3o id\u00eanticas. Portanto, pod\u00edamos tirar a autom\u00e1tica e ter\u00edamos um percurso menos que fazer durante a manuten\u00e7\u00e3o. Uma an\u00e1lise deste tipo pode evitar que tenham que se sacanear inutilmente milh\u00f5es de linhas em manuten\u00e7\u00e3o das bases de dados.<\/p>\n<\/div><\/section>\n\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 sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-106607'><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;\">ELIMINA\u00c7\u00c3O DE DUPLICADOS<\/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;\">Como procuramos estat\u00edsticas duplicadas?<\/h3>\n<p style=\"text-align: center; color: black;\">As anteriores as vemos no Explorador de Objetos:<\/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-5742b3b6677d1ead8de174a7e8f8658d\">\n.avia-image-container.av-av_image-5742b3b6677d1ead8de174a7e8f8658d img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-5742b3b6677d1ead8de174a7e8f8658d .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-5742b3b6677d1ead8de174a7e8f8658d 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-94183 avia-img-lazy-loading-not-94183 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;\">Foquemos que a consulta nos d\u00e1 tanto o nome, como o identificador do campo em decimal e hexadecimal. Para as estat\u00edsticas autom\u00e1ticas, dito identificador hexadecimal est\u00e1 no nome da estat\u00edstica e assim a podemos localizar rapidamente. Num exemplo, o campo IDTASK \u00e9 o segundo e encontramos o duplicado em seguida.<\/p>\n<p style=\"text-align: center;\">Em outras ocasi\u00f5es h\u00e1 que ir analisando cada uma das estat\u00edsticas para encontrar o duplicado. Por exemplo no caso dos \u00edndices \u201cduplicados\u201d:<\/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-94188 avia-img-lazy-loading-not-94188 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;\">Neste caso temos que existem estat\u00edsticas que come\u00e7am pelo campo ATTRIBUTE_ID, o que nos indica uma utilidade adicional deste tipo de an\u00e1lise: algum dos \u00edndices \u00e9 redundante? Para isso recorremos \u00e0 an\u00e1lise standard de uso de \u00edndices e eliminaremos aqueles \u00edndices- o que faz desaparecer a sua estat\u00edstica \u2013 que se atualizam muito e que se usam pouco. Mas em outras ocasi\u00f5es veremos que, ainda h\u00e1 uma poss\u00edvel redund\u00e2ncia, inclusive que um \u00edndice cubra o outro, todos se est\u00e3o a usar para acelerar consultas especificas e por tanto n\u00e3o s\u00e3o necess\u00e1rios. Neste caso \u00e9 melhor deix\u00e1-los.<\/p>\n<\/div><\/section>\n\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 sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-106607'><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=\"Icon: \"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p>Como nota adicional, a tabela anterior d\u00e1-nos mais dados que em certas ocasi\u00f5es nos pode ajudar a analise das bases de dados, como pode ser se a estat\u00edstica \u00e9 de cria\u00e7\u00e3o autom\u00e1tica (campo auto_created), se \u00e9 manual ou de utilizador (user_created) ou se procede de um \u00edndice (ambos campos s\u00e3o zero). Poderia nos servir para vincar a estat\u00edstica com o seu \u00edndice.<br \/>\nTamb\u00e9m se \u00e9 uma estat\u00edstica filtrada. Neste caso n\u00e3o quis retir\u00e1-las porque queria fazer uma an\u00e1lise adicional dos \u00edndices e preferia descarta-los em vez de revis\u00e1-los.<\/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=\"Icon: \"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><section class=\"av_textblock_section \">\n<div class=\"avia_textblock \">\n<p>Por ultimo, o c\u00f3digo exposto n\u00e3o comtempla um bug que existe \u00e0 vista sys.stats_columns e que em ocasi\u00f5es faz com que o dito campo n\u00e3o d\u00ea a ordem real dos campos da estat\u00edstica e que se tenha de acudir \u00e0s vistas de \u00edndice para saber a dita ordem. Vejamos um exemplo:<\/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-122920 avia-img-lazy-loading-not-122920 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 nos fixamos, a ordem das colunas na vista da estat\u00edstica (stats_column_id) \u00e9 muito distinta \u00e0 real que nos indica a vista do \u00edndice (key_ordinal). Por tanto, esta consulta deveria ser melhorada para que, se \u00e9 uma estat\u00edstica de \u00edndice, se buscasse o primeiro campo do \u00edndice em vez do da estat\u00edstica. Mas essa complica\u00e7\u00e3o deixamos como tarefa.<\/p>\n<\/div><\/section>\n\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 sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-106607'><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;\">CONCLUS\u00c3O<\/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;\">Ainda que n\u00e3o seja muito necess\u00e1ria a an\u00e1lise das estat\u00edsticas duplicadas, se usamos os filtros adequados nos podem <strong>indicar as melhorias na manuten\u00e7\u00e3o assim como \u00edndices que podemos eliminar. <\/strong><\/p>\n<\/div><\/section>\n\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 sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-106607'><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-e2221b56e8cbb98b22ad4ac6e1a0335c-wrap avia-button-center '><a href='https:\/\/www.danysoft.com\/pt-pt\/produtos\/noticias-produtos\/'  class='avia-button av-av_button-e2221b56e8cbb98b22ad4ac6e1a0335c 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=\"Not\u00edcias\"><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' >Not\u00edcias<\/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-05c6897d7e21c9074a5441209cf4621c-wrap avia-button-center '><a href='https:\/\/www.danysoft.pt\/comunidade\/seminarios\/'  class='avia-button av-av_button-05c6897d7e21c9074a5441209cf4621c 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=\"Eventos\"><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' >Eventos<\/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-5f93f997fbed0f7da9ab8c94fd34b762-wrap avia-button-center '><a href='https:\/\/www.danysoft.pt\/comunidade\/videos\/'  class='avia-button av-av_button-5f93f997fbed0f7da9ab8c94fd34b762 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=\"V\u00eddeos\"><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' >V\u00eddeos<\/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-180e3e425792284598016a5a0a10b318-wrap avia-button-center '><a href='https:\/\/www.danysoft.pt\/danysoft\/contacto\/'  class='avia-button av-av_button-180e3e425792284598016a5a0a10b318 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=\"Contato\"><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' >Contato<\/span><\/a><\/div><\/div>\n\n<\/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 sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-106607'><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=\"Share on Facebook\" href='https:\/\/www.facebook.com\/sharer.php?u=https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/&#038;t=Estat%C3%ADsticas%20Duplicadas' data-av_icon='\ue8f3' data-av_iconfont='entypo-fontello'  title='' data-avia-related-tooltip='Share on Facebook'><span class='avia_hidden_link_text'>Share on Facebook<\/span><\/a><\/li><li class='av-share-link av-social-link-pinterest avia_social_iconfont' ><a target=\"_blank\" aria-label=\"Share on Pinterest\" href='https:\/\/pinterest.com\/pin\/create\/button\/?url=https%3A%2F%2Fwww.danysoft.com%2Fpt-pt%2Festatisticas-duplicadas%2F&#038;description=Estat%C3%ADsticas%20Duplicadas&#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='Share on Pinterest'><span class='avia_hidden_link_text'>Share on Pinterest<\/span><\/a><\/li><li class='av-share-link av-social-link-linkedin avia_social_iconfont' ><a target=\"_blank\" aria-label=\"Share on LinkedIn\" href='https:\/\/linkedin.com\/shareArticle?mini=true&#038;title=Estat%C3%ADsticas%20Duplicadas&#038;url=https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/' data-av_icon='\ue8fc' data-av_iconfont='entypo-fontello'  title='' data-avia-related-tooltip='Share on LinkedIn'><span class='avia_hidden_link_text'>Share on LinkedIn<\/span><\/a><\/li><li class='av-share-link av-social-link-reddit avia_social_iconfont' ><a target=\"_blank\" aria-label=\"Share on Reddit\" href='https:\/\/reddit.com\/submit?url=https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/&#038;title=Estat%C3%ADsticas%20Duplicadas' data-av_icon='\ue927' data-av_iconfont='entypo-fontello'  title='' data-avia-related-tooltip='Share on Reddit'><span class='avia_hidden_link_text'>Share on Reddit<\/span><\/a><\/li><li class='av-share-link av-social-link-mail avia_social_iconfont' ><a  aria-label=\"Share by Mail\" href='mailto:?subject=Estat%C3%ADsticas%20Duplicadas&#038;body=https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/' data-av_icon='\ue805' data-av_iconfont='entypo-fontello'  title='' data-avia-related-tooltip='Share by Mail'><span class='avia_hidden_link_text'>Share by 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<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='after_section_9'  class='main_color av_default_container_wrap container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-106607'><div class='entry-content-wrapper clearfix'>\n","protected":false},"excerpt":{"rendered":"<p>Que fazer para as procurar e como atuar quando as encontramos<\/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":[3493],"tags":[5513,5511,5512,5514],"class_list":["post-106607","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-artigos","tag-eliminacao-de-duplicados","tag-estatisticas-duplicadas","tag-pesquisa-de-duplicados","tag-sys-stats"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Exist\u00eancia Estat\u00edsticas Duplicadas | Que fazer para as procurar<\/title>\n<meta name=\"description\" content=\"Ainda que a exist\u00eancia de estat\u00edsticas duplicadas n\u00e3o costuma gerar problema porque ocupam pouco espa\u00e7o e n\u00e3o afetam muito o rendimento [...]\" \/>\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\/pt-pt\/estatisticas-duplicadas\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exist\u00eancia Estat\u00edsticas Duplicadas | Que fazer para as procurar\" \/>\n<meta property=\"og:description\" content=\"Ainda que a exist\u00eancia de estat\u00edsticas duplicadas n\u00e3o costuma gerar problema porque ocupam pouco espa\u00e7o e n\u00e3o afetam muito o rendimento [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/\" \/>\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-17T14:54:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-17T14:55:31+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=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Administrador\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"23 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/estatisticas-duplicadas\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/estatisticas-duplicadas\\\/\"},\"author\":{\"name\":\"Administrador\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/#\\\/schema\\\/person\\\/405a8d48d450729ff679467017ba0e23\"},\"headline\":\"Estat\u00edsticas Duplicadas\",\"datePublished\":\"2017-08-17T14:54:19+00:00\",\"dateModified\":\"2017-08-17T14:55:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/estatisticas-duplicadas\\\/\"},\"wordCount\":3695,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/estatisticas-duplicadas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.danysoft.com\\\/wp-content\\\/uploads\\\/2017\\\/08\\\/stormtrooper.jpg\",\"keywords\":[\"ELIMINA\u00c7\u00c3O DE DUPLICADOS\",\"Estat\u00edsticas Duplicadas\",\"pesquisa de duplicados\",\"sys.stats\"],\"articleSection\":[\"Artigos\"],\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/estatisticas-duplicadas\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/estatisticas-duplicadas\\\/\",\"url\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/estatisticas-duplicadas\\\/\",\"name\":\"Exist\u00eancia Estat\u00edsticas Duplicadas | Que fazer para as procurar\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/estatisticas-duplicadas\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/estatisticas-duplicadas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.danysoft.com\\\/wp-content\\\/uploads\\\/2017\\\/08\\\/stormtrooper.jpg\",\"datePublished\":\"2017-08-17T14:54:19+00:00\",\"dateModified\":\"2017-08-17T14:55:31+00:00\",\"description\":\"Ainda que a exist\u00eancia de estat\u00edsticas duplicadas n\u00e3o costuma gerar problema porque ocupam pouco espa\u00e7o e n\u00e3o afetam muito o rendimento [...]\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/estatisticas-duplicadas\\\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/estatisticas-duplicadas\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/estatisticas-duplicadas\\\/#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\\\/pt-pt\\\/estatisticas-duplicadas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/inicio-2-2-2\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Estat\u00edsticas Duplicadas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/#website\",\"url\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/\",\"name\":\"Danysoft\",\"description\":\"Licencias software y servicios de formaci\u00f3n y consultor\u00eda necesarios para su correcto uso\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/#organization\",\"name\":\"Danysoft\",\"url\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/www.danysoft.com\\\/pt-pt\\\/#\\\/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\\\/pt-pt\\\/#\\\/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\\\/pt-pt\\\/#\\\/schema\\\/person\\\/405a8d48d450729ff679467017ba0e23\",\"name\":\"Administrador\",\"sameAs\":[\"https:\\\/\\\/danysoft.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exist\u00eancia Estat\u00edsticas Duplicadas | Que fazer para as procurar","description":"Ainda que a exist\u00eancia de estat\u00edsticas duplicadas n\u00e3o costuma gerar problema porque ocupam pouco espa\u00e7o e n\u00e3o afetam muito o rendimento [...]","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\/pt-pt\/estatisticas-duplicadas\/","og_locale":"pt_PT","og_type":"article","og_title":"Exist\u00eancia Estat\u00edsticas Duplicadas | Que fazer para as procurar","og_description":"Ainda que a exist\u00eancia de estat\u00edsticas duplicadas n\u00e3o costuma gerar problema porque ocupam pouco espa\u00e7o e n\u00e3o afetam muito o rendimento [...]","og_url":"https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/","og_site_name":"Danysoft","article_publisher":"http:\/\/www.facebook.com\/danysoft","article_published_time":"2017-08-17T14:54:19+00:00","article_modified_time":"2017-08-17T14:55:31+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":{"Escrito por":"Administrador","Tempo estimado de leitura":"23 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/#article","isPartOf":{"@id":"https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/"},"author":{"name":"Administrador","@id":"https:\/\/www.danysoft.com\/pt-pt\/#\/schema\/person\/405a8d48d450729ff679467017ba0e23"},"headline":"Estat\u00edsticas Duplicadas","datePublished":"2017-08-17T14:54:19+00:00","dateModified":"2017-08-17T14:55:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/"},"wordCount":3695,"commentCount":0,"publisher":{"@id":"https:\/\/www.danysoft.com\/pt-pt\/#organization"},"image":{"@id":"https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/stormtrooper.jpg","keywords":["ELIMINA\u00c7\u00c3O DE DUPLICADOS","Estat\u00edsticas Duplicadas","pesquisa de duplicados","sys.stats"],"articleSection":["Artigos"],"inLanguage":"pt-PT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/","url":"https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/","name":"Exist\u00eancia Estat\u00edsticas Duplicadas | Que fazer para as procurar","isPartOf":{"@id":"https:\/\/www.danysoft.com\/pt-pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/#primaryimage"},"image":{"@id":"https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.danysoft.com\/wp-content\/uploads\/2017\/08\/stormtrooper.jpg","datePublished":"2017-08-17T14:54:19+00:00","dateModified":"2017-08-17T14:55:31+00:00","description":"Ainda que a exist\u00eancia de estat\u00edsticas duplicadas n\u00e3o costuma gerar problema porque ocupam pouco espa\u00e7o e n\u00e3o afetam muito o rendimento [...]","breadcrumb":{"@id":"https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/www.danysoft.com\/pt-pt\/estatisticas-duplicadas\/#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\/pt-pt\/estatisticas-duplicadas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.danysoft.com\/pt-pt\/inicio-2-2-2\/"},{"@type":"ListItem","position":2,"name":"Estat\u00edsticas Duplicadas"}]},{"@type":"WebSite","@id":"https:\/\/www.danysoft.com\/pt-pt\/#website","url":"https:\/\/www.danysoft.com\/pt-pt\/","name":"Danysoft","description":"Licencias software y servicios de formaci\u00f3n y consultor\u00eda necesarios para su correcto uso","publisher":{"@id":"https:\/\/www.danysoft.com\/pt-pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.danysoft.com\/pt-pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/www.danysoft.com\/pt-pt\/#organization","name":"Danysoft","url":"https:\/\/www.danysoft.com\/pt-pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/www.danysoft.com\/pt-pt\/#\/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\/pt-pt\/#\/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\/pt-pt\/#\/schema\/person\/405a8d48d450729ff679467017ba0e23","name":"Administrador","sameAs":["https:\/\/danysoft.com"]}]}},"_links":{"self":[{"href":"https:\/\/www.danysoft.com\/pt-pt\/wp-json\/wp\/v2\/posts\/106607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.danysoft.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.danysoft.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.danysoft.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.danysoft.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=106607"}],"version-history":[{"count":0,"href":"https:\/\/www.danysoft.com\/pt-pt\/wp-json\/wp\/v2\/posts\/106607\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.danysoft.com\/pt-pt\/wp-json\/wp\/v2\/media\/105882"}],"wp:attachment":[{"href":"https:\/\/www.danysoft.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=106607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.danysoft.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=106607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.danysoft.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=106607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}