{"author_url":"https://blog.hatena.ne.jp/HTN20190109/","description":"MySQL (8.0.26) \u51e6\u7406\u5bfe\u8c61\u4ef6\u6570\u304c\u4e0b\u8a18\u30d1\u30bf\u30fc\u30f3\u3067(1\u5343,1\u5343)(1\u4e07,1\u4e07)(10\u4e07,10\u4e07)(100\u4e07,100\u4e07) HJ = Hash join(Full Scan/Full Scan)NL = Nested loop(Full Scan/Index Lookup)\u3092\u6bd4\u8f03 drop table tab1;create table tab1( col1 bigint ,col2 bigint ); drop table tab2;create table tab2( col1 bigint ,col2 bigint ); drop procedure proc1; delimiter\u2026","categories":["DB"],"title":"HJ/NL\u306e\u5207\u66ff\u4ef6\u6570\u78ba\u8a8d","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2022%2F03%2F05%2F174956\" title=\"HJ/NL\u306e\u5207\u66ff\u4ef6\u6570\u78ba\u8a8d - 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>","blog_url":"https://htn20190109.hatenablog.com/","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","type":"rich","version":"1.0","author_name":"HTN20190109","width":"100%","blog_title":"HTN20190109\u306e\u65e5\u8a18","url":"https://htn20190109.hatenablog.com/entry/2022/03/05/174956","published":"2022-03-05 17:49:56","image_url":null,"height":"190"}