My point was that your explain would be the same with indexes as without as they won’t be used.
Martin. From: Alexander Farber <[email protected]> Date: Wednesday, 21 February 2018 at 12:33 Cc: pgsql-general <[email protected]> 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 <[email protected]> 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
