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

[Martin Moore <martin.moore@xxxxxxxxxxx>]

My point was that your explain would be the same with indexes as without as they won’t be used.

 

Martin.

 

From: Alexander Farber <alexander.farber@xxxxxxxxx>
Date: Wednesday, 21 February 2018 at 12:33
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
Subject: Re: Not sure if I should CREATE INDEX for text columns on which I plan to filter later

 

Hi Martin -

 

On Wed, Feb 21, 2018 at 1:26 PM, Martin Moore <martin.moore@xxxxxxxxxxx> 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