Re: The Missing Piece in Indexing

2019-11-20 Thread Adam Johnson
Hi Behzad Your database will automatically use the appropriate indexes for given queries, thanks to its optimizer. See https://en.m.wikipedia.org/wiki/Query_optimization and DB specific docs such as: https://www.postgresql.org/docs/9.0/planner-optimizer.html , https://dev.mysql.com/doc/internals/e

The Missing Piece in Indexing

2019-11-20 Thread Behzad
Hey all! I noticed a while ago that we can set indexes in the models Meta as described here . But I can't find any commands on the Queryset which helps us use the declared indexes, the equivalent of `USE INDEX` in the DB. Is th