We have some optimization statistics problem.
First we run optimizedb -zk sales
But then we get this messages on every table we try to use on our
application.
E_OP03A2_HISTINCREASING consistency check
- histogram on taliprovta attribute idmes is not monotonically
increasing
We fix this running an optimization at 50% with this command:
optimizedb -zk -zs50.0 ventas -rtaliprovta.
So at noon we run an optimization like this optimizedb -zk -zs50.0
sales, but now the problem persist not in all the table but more than
a 70% of all the database, we are at stage of migration from IngresII
2.6 version, and think maybe in this new version of ingres is diferent
form of optimization somebody can give us a clue?
Thanks in advance.
