Query slow for new participants

2019-02-25 Thread Kim
Hello, I have an article query which returns articles enabled for a participant. Article table – Participant table – Table in between which stores the links between the Article and particitpant including characteristics such as enabled. It is possible to search on the articles by number, descripti

Partial index on enum type is not being used, type issue?

2021-09-27 Thread Kim Johan Andersson
'Ole', and that looks fine. So why is the varchar version not using the index? Any thoughs on this? Regards, Kim Johan Andersson SELECT version(); CREATE TYPE type_table_test_enum AS ENUM ( 'Ole', 'Bole', 'Skole' ); CREATE TABL