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]

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

"Justin" <kfwolf@hotmail .comwrote in message
news:3862e0ee-59af-4637-a292-d40957f85308@n7 5g2000hsh.googl egroups.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]

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

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_namevola tile


On Mar 5, 5:54 pm, "Mark A" <nob...@nowhere .comwrote:

"Justin" <kfw...@hotmail .comwrote in message
>
news:3862e0ee-59af-4637-a292-d40957f85308@n7 5g2000hsh.googl egroups.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]

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

>"Justin" <kfwolf@hotmail .comwrote in message

>news:644176c b-d09b-41af-a452-c708c12e73ef@p2 5g2000hsf.googl egroups.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_namevola tile

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