Re: [HACKERS] optimization join on random value - Mailing list pgsql-general

Yahooo !
Many thanks !

soe=# explain  EXECUTE test( random()*45000 );
                                      QUERY PLAN
-------------------------------------------------------------------------------------
  Index Scan using addresses_cust_ix on addresses (cost=0.43..16.48
rows=3 width=84)
    Index Cond: (customer_id = 13117::bigint)

On 04.05.2015 05:10, Jim Nasby wrote:
> PREPARE test AS SELECT ... WHERE customer_id = $1;
> EXECUTE test( random()*45000 );