[firebird-support] Re: Optimize this simple SQL

[philippe makowski]

Vander Clock Stephane  [2012-01-31 16:30] :
> now with this strategy i don't remenbered, but did i need to keep the
> index
> CREATE INDEX HASH_X1_Y1_IDX ON HASH (X1_Y1);
> CREATE INDEX HASH_X1_Y2_IDX ON HASH (X1_Y2);
> CREATE INDEX HASH_X1_Y3_IDX ON HASH (X1_Y3);
> CREATE INDEX HASH_X1_Y4_IDX ON HASH (X1_Y4);
> CREATE INDEX HASH_X1_Y5_IDX ON HASH (X1_Y5);
> 
> or i can remove them ?
watch the PLAN, and you'll have the answer I guess