Optimizedb - removing stats on specific columns

From: Tony Buckley 
Subject: Re: Optimization Question...
Date: 14 Jul 1996 23:32:38 -0400

On Jul 15,  9:30am, Andrew Price wrote:
> Subject: Optimization Question...
> I have a little problem that I hope somebody can help me with,
> it goes like this...
>
> I have run an optimizedb command on a specific table using the -zx flag
> for all columns. This produced unsatisfactory results
> (all 'Count Values' were set to 2.0) and I find now that I don't want
> these stats on all the columns.
>
> Is there any way of removing stats from specific columns WITHOUT
> 1. Unloading and re-loading this table (using copydb), OR
> 2. create temp table, drop original table, then create orginial table from
> temp table & then performing optimizedb on the columns that I wanted with
> stats ????
>
> Andrew Price
> Chubb Security
> Sydney - Australia
>-- End of excerpt from Andrew Price

Hi Andrew,

There is no need for any unload/reload or creating of tables.
Use 'statdump -zdl mydb -rmytable -acol1 -acol2 ...'.

Hope this helps.

Regards,

Tony

------------------------------------------------------------------------------
Tony Buckley                        	_/_/_/_/_/		
Developer		    		    _/      _/_/    _/ _/_/  _/   _/
Port of Melbourne Authority		    _/	  _/	_/  _/_/ _/  _/   _/
tonyb@pma.vic.gov.au			    _/    _/    _/  _/   _/   _/ _/
					    _/	    _/_/    _/   _/      _/
								     _/ _/
								      _/
------------------------------------------------------------------------------
Ingres Q & A
To William's Home Page
Email William