Is there a way to remove / clear / drop statistics for a singletable?

[Justin]

Is there a way to remove / clear / drop statistics for a single table?

[Mark A]

"Justin" <kf****@hotmail.comwrote in message
news:38**********************************@n75g2000 hsh.googlegroups.com...

>
Is there a way to remove / clear / drop statistics for a single table?

Not exactly, but if you alter the table to "volatile" then DB2 will ignore
the stats (it will use defaults, i.e., same as -1).

[Justin]

Thanks Mark.

As I read from, http://publib.boulder.ibm.com/infoce...n/r0000888.htm
, it appears the syntax is as simple as:

alter table <table_namevolatile
On Mar 5, 5:54*pm, "Mark A" <[e-mail]:

"Justin" <[e-mail] in message

news:38**********************************@n75g2000 hsh.googlegroups.com...

Is there a way to remove / clear / drop statistics for a single table?

Not exactly, but if you alter the table to "volatile" then DB2 will ignore
the stats (it will use defaults, i.e., same as -1).

[Mark A]

>"Justin" <kf****@hotmail.comwrote in message

>news:64**********************************@p25g200 0hsf.googlegroups.com...
Thanks Mark.

As I read from,
http://publib.boulder.ibm.com/infoce...n/r0000888.htm
, it appears the syntax is as simple as:

alter table <table_namevolatile

That's it. It can sometimes solve performance problems that otherwise drive
people crazy.