×

Join predicate push-down optimizations

  • US 20070219951A1
  • Filed: 03/08/2007
  • Published: 09/20/2007
  • Est. Priority Date: 03/15/2006
  • Status: Active Grant
First Claim
Patent Images

1. A computer-implemented method, comprising:

  • generating a transformed query based on a particular query, wherein said particular query includes;

    an outer query;

    a view within a FROM list of the outer query;

    a join predicate that references;

    a column of an outer table of the outer query, anda column returned by the view;

    wherein said view includes;

    a GROUP BY operator that references a certain column upon which the column returned by the view is based, ora DISTINCT operator that references a certain column upon which the column returned by view is based; and

    wherein generating the transformed query includes pushing down the join predicate to create a pushed down join predicate that references the column of the outer table and a certain column returned by the view is based.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×