Re: [Info-Ingres] How to ignore table statistis.

At 12:29 PM -0500 12/9/07, Laframboise André wrote:

We have a set of queries on very large tables that only perform well
if the table statistics are removed. But, without statistics, other queries suffer.

I tried the op165(ingnore stats) trace point and it seems to work well.
Was there ever a 'set nostats' ? It looks familiar but doesn't work.
Maybe it only existed in the universe in my mind......

I'm not crazy about coding trace points in production code.
Is op165 a safe one ? Is it still around in Ingres 2006 ?

I don't think there was ever a set nostats, although I admit
I am going by memory here.

op165 is pretty safe and it's still in Ingres 2006, all releases.

Karl

.

Relevant Pages