Skip to content

Instantly share code, notes, and snippets.

@eiichi-worker

eiichi-worker/memo_2018-01-17-001.md

Last active January 17, 2018 00:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save eiichi-worker/9f6bcfc3f55287dfd9222ff9d314deec to your computer and use it in GitHub Desktop.
Save eiichi-worker/9f6bcfc3f55287dfd9222ff9d314deec to your computer and use it in GitHub Desktop.
Download ZIP
データベースのIndexについて
Raw
memo_2018-01-17-001.md

データベースのIndexについて

Bツリーインデックス (B+ツリーインデックス)

ハッシュインデックス

ビットマップインデックス

  • カーディナリティの低いデータに対して有効（男女とか）

http://itpro.nikkeibp.co.jp/article/COLUMN/20070903/280969/ http://docs.intersystems.com/latestj/csp/docbook/DocBook.UI.Page.cls?KEY=GSQLOPT_indices#GSQLOPT_indices_bitmap_operation

逆キーインデックス

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment