Re: Partitioning

  WITH idlist as (SELECT id from othertable) 

    SELECT id from mastertable WHERE id = idlist.id);

    select mt.id, ...   from mastertable mt join othertable ot on mt.id=ot.id;

might optimize better.

-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast