Updating a column is slow
===

can someone explain to me why updating a table column is using just one of eight possible processors? I think that such a process could be easily subdivided for all available processors?

The query is just like this:

    update
        My_Table
    set
        column2 = 'Atlantic'
    from
        My_Table
    where
        column2 != 'Ocean'

The table in question is about 6GB. The IO Deltas during the query is about 7MB/s which is quite low.

The server is a remote machine and I'm the only user. Parallelism is enabled.

I'm not using indices which I probably should.


Any insight would be very helpful,
Christian