I've run some queries on INVTXN and here's the data.
before consolidate inventory transactions:
file size: 156MB
Code:SELECT COUNT(MTIT_KEY) FROM "INVTXN_B" WHERE MTIT_DATE <= '2006-01-01'
result: 204733
Code:SELECT COUNT(MTIT_KEY) FROM "INVTXN_B" WHERE MTIT_DATE >= '2006-01-01'
result: 78883
after consolidate inventory transactions:
file size: 216MB
Code:SELECT COUNT(MTIT_KEY) FROM "INVTXN_B" WHERE MTIT_DATE <= '2006-01-01'
result: 5360
Code:SELECT COUNT(MTIT_KEY) FROM "INVTXN_B" WHERE MTIT_DATE >= '2006-01-01'
result: 78883 (same)
It does speed up the time it takes to run the first query, and that's all I'm really concerned with. It sure is strange however... ???