Planet DB2
  • About
  • Submit Your Blog
  • Contact Us
Select Page

High Level Db2 Indexing Advice for Large and Small Tables

by Craig S. Mullins | Dec 18, 2019 | clustering, index, primary key, uniqueness

In general, creating indexes to support your most frequent and important Db2 SQL queries is a good idea. But the size of the table will be a factor in decided whether to index at all and/or how many indexes to create.For tables more than 100 (or so) pages, it usually...

High Level Db2 Indexing Advice for Large and Small Tables

by Craig S. Mullins | Dec 18, 2019 | clustering, index, primary key, uniqueness

In general, creating indexes to support your most frequent and important Db2 SQL queries is a good idea. But the size of the table will be a factor in decided whether to index at all and/or how many indexes to create.For tables more than 100 (or so) pages, it usually...

Recent Posts

  • Harnessing the Power of zIIP Processors for Improved Db2 Performance and Lower Cost
  • The DB2Night Show #253: Explain Essentials for Query Optimization
  • A Db2 for z/OS DBA Poem
  • Consider Application-Level Lock Control in Db2 13 for z/OS
  • Choosing the BEST RDBMS

Recent Comments

    Copyright 2020 Planet DB2
    ×

    Submit Your Blog