This question has been flagged
1190 Views

Hi,

I notice that this query takes about 10 seconds on our odoo 12 installation.


SELECT count(u.*)
FROM res_users u
WHERE active=true AND
share=false AND
NOT exists(SELECT 1 FROM res_users_log WHERE create_uid=u.id);


Can I somehow optimize it? For example with an database index?

Avatar
Discard