delete column stats only

[abhaysk]

Originally posted by khussain
is it possible to specify more than one column at a time ?
if yes, please give me an example.

i've tried different combinations, can't get it to work !

Please dont try this

delete from sys.hist_head$ h 
where 
(h.OBJ#,h.COL#) in 
( 
select o.obj#,c.COL# from sys.col$ c, sys.obj$ o, sys.hist_head$ h 
where 
o.OBJ#=c.obj# and 
c.obj#=h.obj# and 
c.col#=h.col# and
o.name='your_table_name' and     -- Table in which you want to delete COL stats
c.name in ('COL1', 'COL2', ... ) -- Columns you want to delete the stats
);

Jurij, Pando yell at me if any thing else is done to delete the statistics for a COLUMN.

Abhay.