> >I've just added a new column to a table, and I am updating it to have a
> >value. The table has only 18000 rows, and yet the query takes
> in the order
> >of 10 minutes to complete. This is the process running:
>
> No triggers or FK constraints etc?
Gah! I just remembered that I have a trigger on the table that updates the
full text index on another table!
Sorry...
Chris