{"published":"2021-05-05 18:52:48","description":"\u305b\u3063\u304b\u304f\u306eGW\u306a\u306e\u3067\u3001\u304a\u3082\u3061\u3083\u3092\u4f5c\u308a\u307e\u3057\u305f\u3002 Query Review Helper\u3067\u3059\u3002 github.com \u80cc\u666f \u6700\u8fd1MySQL\u3067\u5b9f\u884c\u3055\u308c\u308b\u30af\u30a8\u30ea\u3092\u30ec\u30d3\u30e5\u30fc\u3059\u308b\u30bf\u30b9\u30af\u304c\u7570\u5e38\u306b\u591a\u304f\u306a\u3063\u3066\u304d\u307e\u3057\u305f\u3002 \u958b\u767a\u8005\u306e\u5168\u54e1\u304cindex\u3084join, partition, limit offset\u306a\u3069\u306a\u3069\u306e\u30cf\u30de\u308a\u3069\u3053\u308d\u3092\u77e5\u3063\u3066\u3044\u308b\u3068\u3044\u3046\u306e\u304c\u7406\u60f3\u3067\u306f\u3042\u308a\u307e\u3059\u304c\u3001\u305d\u3046\u3082\u884c\u304d\u307e\u305b\u3093\u3002 \u5927\u4f53EXPLAIN\u3092\u304b\u3051\u3066table scan\u306b\u306a\u3063\u3066\u3044\u306a\u3044\u304b\u3001sort\u3084limit offset\u3067\u5287\u7684\u306b\u91cd\u3044\u30af\u30a8\u30ea\u304c\u306a\u3044\u304b\u78ba\u8a8d\u3059\u308c\u3070\u3001\u3059\u3050\u306b\u554f\u984c\u306b\u306a\u308b\u3088\u3046\u306a\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u304c\u3044\u304f\u3064\u304b\u554f\u984c\u304c\u3042\u308a\u307e\u3059\u3002 \u8907\u6570\u306e\u30b5\u30fc\u30d3\u30b9\u3092\u6a2a\u4e32\u306b\u898b\u3066\u3044\u2026","title":"MySQL\u306equery review helper\u3092\u4f5c\u3063\u3066\u307f\u305f","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftombo2.hatenablog.com%2Fentry%2F2021%2F05%2F05%2F185248\" title=\"MySQL\u306equery review helper\u3092\u4f5c\u3063\u3066\u307f\u305f - tom__bo\u2019s Blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"tom__bo\u2019s Blog","blog_url":"https://tombo2.hatenablog.com/","version":"1.0","provider_url":"https://hatena.blog","height":"190","provider_name":"Hatena Blog","author_name":"tom__bo","author_url":"https://blog.hatena.ne.jp/tom__bo/","width":"100%","categories":["MySQL","MySQL 8.0"],"url":"https://tombo2.hatenablog.com/entry/2021/05/05/185248","type":"rich","image_url":null}