{"provider_name":"Hatena Blog","published":"2019-07-22 12:26:48","width":"100%","type":"rich","blog_url":"https://www.shigemk2.com/","height":"190","image_url":null,"provider_url":"https://hatena.blog","version":"1.0","blog_title":"by shigemk2","author_name":"shigemk2","url":"https://www.shigemk2.com/entry/2019/07/22/122648","description":"ROW_NUMBER\u306f\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u60aa\u3044\u3057\u30e1\u30e2\u30ea\u3082\u591a\u304f\u4f7f\u3046\u304b\u3089\u9045\u3044\u306e\u3067RANK\u304bDENSE_RANK\u3092\u4f7f\u3048\u3063\u3066\u3053\u3068\u3060\u3051\u30690.201\u304b\u3089ROW_NUMBER\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304b\u306a\u308a\u6539\u5584\u3055\u308c\u3066\u308b\u3063\u307d\u3044\u3002 \u3061\u3087\u3063\u3068\u8aad\u307f\u5207\u308c\u306a\u3044\u3068\u3053\u3042\u308b\u3051\u3069SqlTopNRowNumberBenchmark\u306e\u7d50\u679c\u3092\u898b\u3066\u3082RANK\u3068ROW_NUMBER\u3067\u3042\u3093\u307e\u308a\u905c\u8272\u306a\u3044\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306b\u306a\u3063\u3066\u308b\u3002 commit c2affb70afb5d236f011bed2fc6e5fab2dc43d47 Author: James Sun <jamessun@fb.com> Date: Thu Apr 26 19:12:02 2018\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.shigemk2.com%2Fentry%2F2019%2F07%2F22%2F122648\" title=\"Presto-Performance-Tuning ROW_NUMBER 2019 - by shigemk2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_url":"https://blog.hatena.ne.jp/shigemk2/","categories":["Presto"],"title":"Presto-Performance-Tuning ROW_NUMBER 2019"}