{"version":"1.0","author_url":"https://blog.hatena.ne.jp/HTN20190109/","description":"Oracle exec dbms_stats.gather_table_stats('TEST','TAB1'); MySQL analyze table tab6; PostgreSQL analyze verbose tab1; SQL Server \u203b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u306a\u3044\u5834\u5408\u3001\u7d71\u8a08\u60c5\u5831\u306f\u53d6\u5f97\u3055\u308c\u306a\u3044 --\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u5168\u30c6\u30fc\u30d6\u30ebUSE test; GO EXEC sp_updatestats; go --\u7279\u5b9a\u306e\u30c6\u30fc\u30d6\u30ebUSE test; GO UPDATE STATISTICS dbo.tab1; GO","height":"190","title":"\u30d7\u30e9\u30f3\u30ca\u7d71\u8a08\u60c5\u5831\u53d6\u5f97","url":"https://htn20190109.hatenablog.com/entry/2019/03/26/001516","categories":["DB"],"width":"100%","type":"rich","provider_name":"Hatena Blog","author_name":"HTN20190109","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2019%2F03%2F26%2F001516\" title=\"\u30d7\u30e9\u30f3\u30ca\u7d71\u8a08\u60c5\u5831\u53d6\u5f97 - HTN20190109\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2019-03-26 00:15:16","blog_title":"HTN20190109\u306e\u65e5\u8a18","provider_url":"https://hatena.blog","blog_url":"https://htn20190109.hatenablog.com/","image_url":null}