search

kayak / pypika

PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
http://pypika.readthedocs.io/en/latest/
Apache License 2.0
2.43k stars 293 forks source link

Add force index for joins #722

Open RonNabuurs opened 1 year ago

RonNabuurs commented 1 year ago

This PR adds the ability to use FORCE INDEX on JOINS.

Sometimes the query optimizer just needs a tiny hint for what indexes it needs to use.