Paul J Stevens wrote:
Michael Mayer wrote:
But especially the messages
table seems to be over-indexed.
Please propose a better index setup.
As I said, I would check the performance without mailbox_idnr_index in
the first step, because the column is already contained in
mailbox_status - the optimizer should notice that. I do not have large
enough tables with real-world data to perform tests - so any
recommendation is pure theory at the moment.
Michael
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
