Postgres: Optimize Query
I have a situation where I need to show a list of subjects to which a learning material or a test has been published to. The query below works but it takes about ~8s. Is there a better way I can optimize this query? Thank you. SELECT sj.*, sj.id AS id FROM subjects sj WHERE […]