473,398 Members | 2,427 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,398 software developers and data experts.

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 2951
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
by: Felix | last post by:
Dear Sql Server experts: First off, I am no sql server expert :) A few months ago I put a database into a production environment. Recently, It was brought to my attention that a particular...
2
by: yongsing | last post by:
I have two tables as shown below (only relevant columns shown). The second table is dependent on the first one. CREATE TABLE PARENTTABLE ( ... SERIAL CHAR(12) NOT NULL, ENDDATE TIMESTAMP NOT...
6
by: Ahmet Bilgili | last post by:
Hi, We have been using a long select-subselect query on a db2 server on aix , the operation was taking nearly 4 minutes , but a mystical kind of thing happened which we dont know, and the query...
4
by: Bruce | last post by:
I have a table with some sensitive customer data in it. I am now keeping all the data in another table, and encrypting it. I want to get rid of the original unencrypted data and be sure that it...
2
by: Ryan | last post by:
I have a dropdown list bound to a datasource. I would like to clear it at the press of a button. I tried using the following code: mydropdown.Items.Clear() The end result is that it comes...
4
by: traceable1 | last post by:
I am trying to improve the performance of a query. No matter how bad it runs the first time, it runs really fast the second time. So how can I tell if I've done anything to improve the query if...
17
by: romixnews | last post by:
Hi, I'm facing the problem of analyzing a memory allocation dynamic and object creation dynamics of a very big C++ application with a goal of optimizing its performance and eventually also...
1
by: ken | last post by:
How to remove specified cookie (via a given name) in cookie jar? I have the following code, but how can I remove a specified cookie in the cookie jar? cj = cookielib.LWPCookieJar() if cj is...
11
by: Richard Maher | last post by:
Hi, I have read many of the copius entries on the subject of IE performance (or the lack thereof) when populating Select Lists. I don't mind the insert performance so much, (I get 100x120byte...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.