Home > mailing lists

Index creation - Mailing list pgsql-sql

From	Yambu
Subject	Index creation
Date	May 24, 2021 06:41:41
Msg-id	CALhHtcCO=nBCBRMJfx_s9dGMwPRoH+GmBQSC2X8bGgGLE-OA6A@mail.gmail.com Whole thread Raw
Responses	Re: Index creation (David Rowley <dgrowleyml@gmail.com>) RE: Index creation (Marc Mamin <M.Mamin@intershop.de>)
List	pgsql-sql

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

From: Bo Guo
Date: 23 May 2021, 05:36:52
Subject: Re: Getting transaction details from the WAL?

From: David Rowley
Date: 24 May 2021, 07:00:17
Subject: Re: Index creation