RE: Index creation

Hi,

beside the other comments, you may try to rework your query to reduce the OR clauses which rise the uncertainty for the planner.

e.g.:

SELECT
*
FROM
table_name
WHERE code_id IN ( 1, 2)

UNION

SELECT
*
FROM
table_name
WHERE (code_id = 3 AND created_date < now())
LIMIT 1

From: Yambu [mailto:hyambu(at)gmail(dot)com]
Sent: Montag, 24. Mai 2021 05:42
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Index creation

hello people, I would like to create an index so that the query on here can use it,

SELECT

*

FROM

table_name

WHERE (code_id = 1

OR code_id = 2

OR (code_id = 3

AND created_date < now()))
LIMIT 1;

please advise me on how I should create index. I created index on code_id but it's not being used