{"author_name":"HTN20190109","description":"Oracle (12R1) --\u30c7\u30fc\u30bf\u6e96\u5099 drop table tab1 purge;create table tab1(col1 int,col2 int); declare beginfor i in 1..10000 loop insert into tab1 values(i,i); commit;end loop;end;/ exec dbms_stats.gather_table_stats('TEST','TAB1'); select * from user_tab_statistics where table_name = 'TAB1'; exec dbms_stats.dr\u2026","author_url":"https://blog.hatena.ne.jp/HTN20190109/","version":"1.0","provider_url":"https://hatena.blog","height":"190","url":"https://htn20190109.hatenablog.com/entry/2019/09/22/002222","type":"rich","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2019%2F09%2F22%2F002222\" title=\"\u7d71\u8a08\u60c5\u5831\u79fb\u884c\u4e2d\u306e\u66f4\u65b0 - 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>","width":"100%","blog_title":"HTN20190109\u306e\u65e5\u8a18","image_url":null,"title":"\u7d71\u8a08\u60c5\u5831\u79fb\u884c\u4e2d\u306e\u66f4\u65b0","provider_name":"Hatena Blog","blog_url":"https://htn20190109.hatenablog.com/","categories":["DB"],"published":"2019-09-22 00:22:22"}