When using count(*), indexes are used whenever possible to avoid hitting the table data and outer joins are ignored altogether. It limits searches quit as soon as they reach the proper count.
Tags: django ORM