P
Patrice Perrot
Guest
Hi Just a little warnng On "Now that we need to do D&L, I can deactivate these indexes. Will help for idxbuild time, db size and general perf." If you do an Idxbuild all on your DB , it wil reactivate the deactivate index … Exemple : i deactivate 2 index on table item (Category2ItemName and CategoryItemName) of sports2000 . DBANALYS : PUB.Item CatDescription 18 1 2 3 4.1K 34.5 2.3 Category2ItemName (inactive) 19 2 1 1 958.0B 23.5 1.0 CategoryItemName (inactive) 20 2 1 1 1.0K 26.1 1.0 ItemName 21 1 1 1 934.0B 23.0 1.0 ItemNum 17 1 1 1 503.0B 12.4 1.0 I did " proutil sports2000 -C idxbuild all " DBANALYS : PUB.Item CatDescription 18 1 2 3 4.1K 34.6 2.3 Category2ItemName 19 2 1 1 958.0B 23.5 1.0 CategoryItemName 20 2 1 1 1.0K 26.1 1.0 ItemName 21 1 1 1 934.0B 23.0 1.0 ItemNum 17 1 1 1 503.0B 12.4 1.0 The deactivate index on item are "ACTIVE" ... Patrice
Continue reading...
Continue reading...