phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Pernollet <mpernol...@octo.com>
Subject EXPLAIN has similar output for filters on indexed and non indexed column
Date Wed, 01 Jul 2015 13:05:53 GMT
Hi,

I want to perform :
SELECT * FROM "table" where "family"."column1" = 'value'

Running an EXPLAIN on this request before creating an index on a column
gives :

CLIENT PARALLEL 1-WAY FULL SCAN OVER table
  SERVER FILTER BY family.column1 = 'value'

Looks OK.
Then I simply :
CREATE INDEX "table_IDX_column1" on "table" ("family"."column1");

Following requests using a filter on indexed column are definitely faster.

However, when *running EXPLAIN again I have exactly the same output*
mentioning a full scan.

I am not familiar with Phoenix explain plan, but I would expect 1 GET on
the index table, and then 1 get in my main table. Isn't it?

Mime
View raw message