Metadata-Version: 1.0
Name: user-query-optimizer
Version: 0.1.0
Summary: SQL query optimization hints
Home-page: https://github.com/mozilla/user-query-optimizer
Author: Swathi Iyer
Author-email: swathii@stanford.edu
License: LICENSE.txt
Description: 
        ## Introduction
        This API will help you optimize your sql queries for better performance.
        
        ## Workflow
        
        ### Create the optimizer object
        Object specific to a single (query, schema) pair
        e.g. `optimizer = Optimizer(query, schema)`
        
        ### Get optimization hints using `optimize_query()`
        Output: optimization hints
        
        Usage: `optimizer.optimize_query()`
        
        Initial Optimization Checks
          * Using approximate algorithms (`approx_distinct()` instead of `COUNT(DISTINCT ...)`)
          * Selecting the columns the user wants explicitly, rather than using `(SELECT *)`
          * Filtering on partitioned columns
          * Try to extract nested subqueries using a WITH clause.
        
        Other Stuff
          * Eliminate date_parse overhead
          * Replace UNION with UNION ALL if duplicates do not need to be removed
          * Aggregate a series of LIKE clauses into one regexp_like expression
          * Push down a complex join condition into a sub query
          * Specify GROUP BY targets with numbers for expressions
        
        ### Testing
        To run unit tests, run `py.test` (or `py.test -s` to see stdout) in the tests directory.
        
Platform: UNKNOWN
