SQLalchemy specify which index to use
I think you can use with_hint() for this.
e.g.
session.query(Model).with_hint(Model, 'USE INDEX col1_index')Honestly, I didn't really know about this; I discovered it by finding 'USE INDEX' in their ORM tests.
I think you can use with_hint() for this.
e.g.
session.query(Model).with_hint(Model, 'USE INDEX col1_index')Honestly, I didn't really know about this; I discovered it by finding 'USE INDEX' in their ORM tests.