Re: Partitioning

[John R Pierce <pierce@xxxxxxxxxxxx>]

On 1/18/2015 5:58 PM, James Sewell wrote:

  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