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
select o.obj#,c.COL# from sys.col$ c, sys.obj$ o, sys.hist_head$ h
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.
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"