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