SQLalchemy specify which index to use

Question

Is there a way in SQLalchemy to tell the query which index to use?

The reason I need this is that the SQL queries it generates use the “wrong” index – there exists an index for exactly the two fields that I have and it doesn’t use it.

Thanks!

Answer

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.

Accepted Answer

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

Advertisement

Answer