Re: Index creation

Поиск
Список
Период
Сортировка
От Yambu
Тема Re: Index creation
Дата
Msg-id CALhHtcARF_p4S+suVhvHWGXk20fTmfO+VwS=SbDZUcCtMwAcUA@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Index creation  (Marc Mamin <M.Mamin@intershop.de>)
Список pgsql-sql
Noted with thanks. 

On Tue, May 25, 2021 at 9:44 AM Marc Mamin <M.Mamin@intershop.de> wrote:

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@gmail.com]
Sent: Montag, 24. Mai 2021 05:42
To: pgsql-sql@lists.postgresql.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

В списке pgsql-sql по дате отправления:

Предыдущее
От: Marc Mamin
Дата:
Сообщение: RE: Index creation
Следующее
От: Yambu
Дата:
Сообщение: Select for update