G
George Potemkin
Guest
> I would still love to hear more about this table! I believe you ... but it seems very hard to envision how we could ever manage a table like this ourselves. And I want to get the whole story in case I ever need to retell it to someone. BTW, there are the tables with similar size in the other branches of the same customer. The customer does not add new indexes to this table. The existent indexes: Table Index Fields Levels Blocks Size % Util Factor PUB.table index1 9 3 5 53213748 114.8G 28.4 2.4 index2 10 3 4 21102108 89.1G 55.6 1.9 index3 8 6 5 144165188 680.6G 62.1 1.8 index4 11 2 4 30022068 129.1G 56.6 1.9 ------------------------------------------------------------------ Totals: 248503234 1013.7G 53.6 1.9 There is a real problem with such large tables: it's not possible to check the health of its indexes for a reasonable timeframe. The fastest way is to build the indexes from a scratch. We can only trust that the indexes are not corrupted.
Continue reading...
Continue reading...