That's a Large number of columns; I suppose the alternative would be to =
put the float fields into a child table but I would imagine that, on =
most systems, the time to find and update 800 child records might =
compare to the time to find and update a single, large, row.
johndpenrose_at_my-dejanews.com wrote in message =
<787cop$hdo$1_at_nnrp1.dejanews.com>...
>I am updating a table that has about 800 fields, and the update =
statement
>takes over two seconds to execute in fiao5.
>
>The table has 2 ints, 1 number(1), and 800 floats. The two ints and 1 =
number
>field make up an index. The where clause uses these three indexed =
fields.
Received on Mon Jan 25 1999 - 10:23:48 CST
