{"id":374,"date":"2012-09-03T02:42:29","date_gmt":"2012-09-03T02:42:29","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=374"},"modified":"2012-09-03T02:42:29","modified_gmt":"2012-09-03T02:42:29","slug":"objects-without-stats","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=374","title":{"rendered":"Objects without stats"},"content":{"rendered":"<p><code><br \/>\n<script type=\"text\/javascript\"> \nfunction copy(what) {\n    window.clipboardData.setData('Text',what.value);\n}\nfunction paste(what) {\n    what.value = window.clipboardData.getData('Text');\n}\n<\/script><\/p>\n<h2>\nObject without stats<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nSET LINESIZE 145\r\nSET PAGESIZE 9999\r\nSET VERIFY   off\r\n\r\nCOLUMN owner            FORMAT a17    HEAD 'Owner'\r\nCOLUMN object_type      FORMAT a15    HEAD 'Object Type'\r\nCOLUMN object_name      FORMAT a30    HEAD 'Object Name'\r\nCOLUMN partition_name   FORMAT a30    HEAD 'Partition Name'\r\n\r\nSELECT\r\n    owner           owner\r\n  , 'Table'         object_type\r\n  , table_name      object_name\r\n  , NULL            partition_name\r\nFROM\r\n    sys.dba_tables \r\nWHERE\r\n      last_analyzed IS NULL \r\n  AND owner NOT IN ('SYS','SYSTEM') \r\n  AND partitioned = 'NO' \r\nUNION \r\nSELECT\r\n    owner           owner\r\n  , 'Index'         object_type\r\n  , index_name      object_name\r\n  , NULL            partition_name\r\nFROM\r\n    sys.dba_indexes \r\nWHERE\r\n      last_analyzed IS NULL \r\n  AND owner NOT IN ('SYS','SYSTEM') \r\n  AND partitioned = 'NO' \r\nUNION \r\nSELECT\r\n    table_owner       owner\r\n  , 'Table Partition' object_type\r\n  , table_name        object_name\r\n  , partition_name    partition_name\r\nFROM\r\n    sys.dba_tab_partitions \r\nWHERE\r\n      last_analyzed IS NULL \r\n  AND table_owner NOT IN ('SYS','SYSTEM') \r\nUNION \r\nSELECT\r\n    index_owner       owner\r\n  , 'Index Partition' object_type\r\n  , index_name        object_name\r\n  , partition_name    partition_name\r\nFROM\r\n    sys.dba_ind_partitions \r\nWHERE\r\n      last_analyzed IS NULL \r\n  AND index_owner NOT IN ('SYS','SYSTEM')\r\nORDER BY\r\n    1\r\n  , 2\r\n  , 3\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nSET LINESIZE 145<br \/>\nSET PAGESIZE 9999<br \/>\nSET VERIFY   off<\/p>\n<p>COLUMN owner            FORMAT a17    HEAD 'Owner'<br \/>\nCOLUMN object_type      FORMAT a15    HEAD 'Object Type'<br \/>\nCOLUMN object_name      FORMAT a30    HEAD 'Object Name'<br \/>\nCOLUMN partition_name   FORMAT a30    HEAD 'Partition Name'<\/p>\n<p>SELECT<br \/>\n    owner           owner<br \/>\n  , 'Table'         object_type<br \/>\n  , table_name      object_name<br \/>\n  , NULL            partition_name<br \/>\nFROM<br \/>\n    sys.dba_tables<br \/>\nWHERE<br \/>\n      last_analyzed IS NULL<br \/>\n  AND owner NOT IN ('SYS','SYSTEM')<br \/>\n  AND partitioned = 'NO'<br \/>\nUNION<br \/>\nSELECT<br \/>\n    owner           owner<br \/>\n  , 'Index'         object_type<br \/>\n  , index_name      object_name<br \/>\n  , NULL            partition_name<br \/>\nFROM<br \/>\n    sys.dba_indexes<br \/>\nWHERE<br \/>\n      last_analyzed IS NULL<br \/>\n  AND owner NOT IN ('SYS','SYSTEM')<br \/>\n  AND partitioned = 'NO'<br \/>\nUNION<br \/>\nSELECT<br \/>\n    table_owner       owner<br \/>\n  , 'Table Partition' object_type<br \/>\n  , table_name        object_name<br \/>\n  , partition_name    partition_name<br \/>\nFROM<br \/>\n    sys.dba_tab_partitions<br \/>\nWHERE<br \/>\n      last_analyzed IS NULL<br \/>\n  AND table_owner NOT IN ('SYS','SYSTEM')<br \/>\nUNION<br \/>\nSELECT<br \/>\n    index_owner       owner<br \/>\n  , 'Index Partition' object_type<br \/>\n  , index_name        object_name<br \/>\n  , partition_name    partition_name<br \/>\nFROM<br \/>\n    sys.dba_ind_partitions<br \/>\nWHERE<br \/>\n      last_analyzed IS NULL<br \/>\n  AND index_owner NOT IN ('SYS','SYSTEM')<br \/>\nORDER BY<br \/>\n    1<br \/>\n  , 2<br \/>\n  , 3<br \/>\n\/<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Object without stats SET LINESIZE 145 SET PAGESIZE 9999 SET VERIFY off COLUMN owner FORMAT a17 HEAD &#8216;Owner&#8217; COLUMN object_type FORMAT a15 HEAD &#8216;Object Type&#8217; COLUMN object_name FORMAT a30 HEAD &#8216;Object Name&#8217; COLUMN partition_name FORMAT a30 HEAD &#8216;Partition Name&#8217; SELECT owner owner , &#8216;Table&#8217; object_type , table_name object_name , NULL partition_name FROM sys.dba_tables WHERE last_analyzed [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":237,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-374","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-62","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/374","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=374"}],"version-history":[{"count":1,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/374\/revisions"}],"predecessor-version":[{"id":375,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/374\/revisions\/375"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/237"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}