Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later
Дата
Msg-id CAADeyWiEQvKv5oA2q+F6auRDzk3svBL1=KK_wKSd+tNmrC5R9w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later  (Martin Moore <martin.moore@avbrief.com>)
Ответы Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later  (Alexander Farber <alexander.farber@gmail.com>)
Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later  (Bill Moran <wmoran@potentialtech.com>)
Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later  (Martin Moore <martin.moore@avbrief.com>)
Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-general
Дерево обсуждения
Hi Martin -

On Wed, Feb 21, 2018 at 1:26 PM, Martin Moore <martin.moore@avbrief.com> wrote:

I’m no expert but I’d think it unlikely an index would be considered for a table with only 100 rows in. Also I’m pretty sure only one index per table is used, so you’d want to put state1 and state2 in one index.


I hope to have more records in the words_games table later when my game is launched (currently in soft launch/beta).....

Regards
Alex

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

Предыдущее
От: Martin Moore
Дата:
Сообщение: Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later
Следующее
От: Alexander Farber
Дата:
Сообщение: Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later