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...
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 Comments