×

OPTIMIZATION TECHNIQUES FOR LINEAR RECURSIVE QUERIES IN SQL

  • US 20070239691A1
  • Filed: 04/05/2007
  • Published: 10/11/2007
  • Est. Priority Date: 04/06/2006
  • Status: Abandoned Application
First Claim
Patent Images

1. A method of evaluating an SQL recursive query having one or more base select statements and one or more recursive select statements, the query relating to a base table and having a filter condition on one or more columns from a result table returned by the query, the method comprising:

  • receiving the query to be evaluated;

    evaluating a base step by evaluating one or more of the base select statements;

    evaluating one or more recursive steps by evaluating one or more of the recursive select statements;

    evaluating the filter condition prior to evaluating any of the recursive steps; and

    returning the result of the query.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×