I'd say it's a 1 insert for 5 - 10 updates.
As for the index on the status, it's because we have a job that runs every
night that deals with conversations in specific statuses. Having a low
cardinality index that changes frequently seems prone to mis-use by the
system. -> What would be an alterna
Hi,
Thanks in advance for your help. I'm putting as much context and details as
possible, but let me know if you have any questions.
What?
We are experiencing some slow queries due to the query planner using an
incorrect index. It is using an unoptimized index because the stats are
computed duri
