Well that explains it. many thanks.

This leads me to another question the reasion I did this was that i want to archive of some data from 'current' table (10 mil...

Hi I am having this problem and I see you are advising against queries like

insert newtable

select * from oldtable where date > 3months

(about a years worth thought it be quickest...

well this is the problem i know my manager explaining what improvements could be made will not impress him. As far as he is concerned he thinks everythings okay despite...