468,103 Members | 1,189 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,103 developers. It's quick & easy.

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


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

Mar 5 '08 #1
3 2754
"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).
Mar 5 '08 #2
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" <nob...@nowhere.comwrote:
"Justin" <kfw...@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).
Mar 6 '08 #3
>"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.
Mar 7 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by yongsing | last post: by
6 posts views Thread by Ahmet Bilgili | last post: by
4 posts views Thread by Bruce | last post: by
2 posts views Thread by Ryan | last post: by
11 posts views Thread by Richard Maher | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.