您好,欢迎来到九壹网。
搜索
您的当前位置:首页IndexingRulesofThumbIndexSelectionDecisions

IndexingRulesofThumbIndexSelectionDecisions

来源:九壹网


Indexing Rules of Thumb : Index every primary key and most foreign keys in the database. Attributes frequently referenced in SQL WHERE clauses are potentially good candidates for an index. Use a B+tree index for bothequality and range quer

Indexing Rules of Thumb :

  • Index every primary key and most foreign keys in the database.
  • Attributes frequently referenced in SQL WHERE clauses are potentially
    good candidates for an index.
  • Use a B+tree index for both equality and range queries.
  • Choose carefully one clustered index for each table.
  • Avoid or remove redundant indexes.
  • Add indexes only when absolutely necessary.
  • Add or delete index columns for composite indexes to improve performance.
    Do not alter primary key columns.
  • Use attributes for indexes with caution when they are frequently updated.
  • Keep up index maintenance on a regular basis; drop indexes only when
    they are clearly hurting performance.
  • Avoid extremes in index cardinality and value distribution.
  • Covering indexes (index only) are useful, but often overused.
  • Use bitmap indexes for high-volume data, especially in data warehouses.
  • Index Selection Decisions :

  • Does this table require an index or not, and if so which search
    key should I build an index on?
  • When do I need multi-attribute (composite) search keys, and
    which ones should I choose?
  • Should I use a dense or sparse index?
  • When can I use a covering index?
  • Should I create a clustered index?
  • Is an index still preferred when updates are taken into
    account? What are the tradeoffs between queries and updates for each index chosen?
  • How do I know I made the right indexing choice?
  • --

    ,网站空间,网站空间,空间

    Copyright © 2019- 91gzw.com 版权所有 湘ICP备2023023988号-2

    违法及侵权请联系:TEL:199 18 7713 E-MAIL:2724546146@qq.com

    本站由北京市万商天勤律师事务所王兴未律师提供法律服务