{"categories":["DB"],"width":"100%","version":"1.0","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2019%2F02%2F23%2F004219\" title=\"\u30b0\u30ed\u30fc\u30d0\u30eb\u5909\u6570 - 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>","image_url":null,"title":"\u30b0\u30ed\u30fc\u30d0\u30eb\u5909\u6570","url":"https://htn20190109.hatenablog.com/entry/2019/02/23/004219","type":"rich","published":"2019-02-23 00:42:19","author_url":"https://blog.hatena.ne.jp/HTN20190109/","provider_name":"Hatena Blog","blog_url":"https://htn20190109.hatenablog.com/","blog_title":"HTN20190109\u306e\u65e5\u8a18","author_name":"HTN20190109","description":"Oracle show parametershow parameter optimizer_index_cost_adj alter system set optimizer_index_cost_adj = 200 scope=both sid='*'; alter session set optimizer_index_cost_adj = 201; MySQL \u203b\u5909\u6570\u540d\u5185\u306e\u4e0b\u7dda\u3092\u30c0\u30c3\u30b7\u30e5\u3068\u3057\u3066\u6307\u5b9a\u3067\u304d\u307e\u3059 show variables;show variables like '%innodb%';show variables like '%INNOdb%'; \u203blike\u6761\u4ef6\u306f\u5927\u6587\u5b57\u5c0f\u6587\u5b57\u2026","height":"190"}