Posted by laurenq uantrell on 12/21/05 19:48

I just finished running un update query on this table - which currently
6.5 is million rows. The update query inserted a single digit into a
tinyint column for every row based on a join on a char(1) column in the
table -- this update query took 14 1/2 hours!!!!
I'd call this unworkable...

• Next in forum: Re: TransferText dropping fractions
• Prev in forum: Re: operand type clash
• Thread view: Re: Maximum UNION statements in a query

[Reply to this message]