Apart from hacking the scomplete flag in iistatistics is there a
"respectable" way to clear the complete flag on an attribute?

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.

Hi Roy,

does it mean your stats are collected with the [optimizedb] -zw flag ?
See http://docs.ingres.com/Ingres/9.2/Co...bcmd.htm#o1231

Stats are supposed, by default, "not complete", till the -zw flag is used.

Except deleting stats with statdump and recreate them without this
flag, I don't know ...

HTH ... (but not sure at all).
--
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jean-pierre.zuate (AT) lafageconseil (DOT) fr
http://lafageconseil.fr/



2009/11/12 Roy Hann <specially (AT) processed (DOT) almost.meat>:

Jean-Pierre Zuate, La Fage Conseil wrote:

Yep, that's the one I mean.

Well just for clarity, "complete" doesn't refer to the statistics, it
refers to the set of values in the column. If you have a master-detail
relationship then the master key column is complete with respect to the
detail foreign key column; i.e. "complete" implies a referential
integrity constraint. It discourages the optimizer from
underestimating the cardinality of the join. (I don't think the
way the complete flag is interpreted is quite right, but it is helpful
more often than it's harmful, I find.)

Thanks Jean-Pierre, I was afraid that is the case.

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.