My post commands are very slow.

I am selecting records "where status=1", dealing with them, then
changing Status to 2. Status is not an indexed field. The SELECT
command is more complex, there are other "wheres", but no other fields
are being changed.

Since status has low selectivity - there are about 6 choices, over about
5 million records - then I can guess why there might be a problem
(index? record moving out of "where" condition?). But I have no idea
what to do about it...

Any suggestions?

--
Pete Clark