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

  • Internship at IBM: A Life-Changing Experience Awaits You
  • Blog series on cloud security and account cleanup
  • Db2 for z/OS: Two Stories of Temporary Tables
  • Selecting From … Nothing
  • What I liked about IBM TechXchange

Recent Comments

    Copyright 2020 Planet DB2
    ×

    Submit Your Blog