{"image_url":"http://cdn-ak.f.st-hatena.com/images/fotolife/h/h13i32maru/20130105/20130105165831.png","author_url":"https://blog.hatena.ne.jp/h13i32maru/","provider_name":"Hatena Blog","height":"190","published":"2012-07-01 00:00:00","author_name":"h13i32maru","version":"1.0","title":"\u306a\u305cBTree\u304cIndex\u306b\u4f7f\u308f\u308c\u3066\u3044\u308b\u306e\u304b","description":"\u203b\u3053\u306e\u5185\u5bb9\u306f\u500b\u4eba\u7684\u306a\u8003\u5bdf\u306a\u306e\u3067\u3001\u9593\u9055\u3063\u3066\u3044\u308b\u7b87\u6240\u3082\u3042\u308b\u3068\u601d\u3044\u307e\u3059\u3002\u305d\u3046\u3044\u3046\u90e8\u5206\u3092\u898b\u3064\u3051\u305f\u969b\u306f\u305c\u3072\u6559\u3048\u3066\u4e0b\u3055\u3044\u3002 RDBMS\u306e\u691c\u7d22\u3092\u65e9\u304f\u3059\u308b\u305f\u3081\u306bIndex\u3063\u3066\u4f7f\u3044\u307e\u3059\u3088\u306d\u3002\u4f8b\u3048\u3070\u3053\u3093\u306a\u30c6\u30fc\u30d6\u30eb CREATE TABLE user ( id INT UNSIGNED NOT NULL, name VARCHAR(255) NOT NULL, UNIQUE INDEX (id) ); id\u30ab\u30e9\u30e0\u306bIndex\u3092\u5f35\u3063\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u306fid\u3067\u306e\u691c\u7d22\u3092\u9ad8\u901f\u306b\u3059\u308b\u305f\u3081\u3067\u3059\u3002\u3053\u3053\u3067id\u30ab\u30e9\u30e0\u306bIndex\u304c\u8cbc\u3063\u3066\u3044\u306a\u3044\u5834\u5408\u3068\u6bd4\u3079\u308b\u3068\u691c\u7d22\u6642\u9593\u304c\u5927\u5e45\u306b\u5909\u308f\u3063\u3066\u304d\u3066\u3057\u307e\u3044\u307e\u3059\uff08\u7279\u306b\u30ec\u30b3\u30fc\u30c9\u304c\u591a\u304f\u306a\u3063\u305f\u6642) \u3067\u306f\u306a\u305cIn\u2026","categories":["tech"],"provider_url":"https://hatena.blog","blog_title":"maru source","width":"100%","url":"https://blog.h13i32maru.jp/entry/2012/07/01/000000","type":"rich","blog_url":"https://blog.h13i32maru.jp/","html":""}