unique_indexed_column_query.py

# these 2 queries are faster because upc & id are unique and indexed.
product = Product.objects.get(upc='PXO01')
product = Product.objects.get(id=33)

# this is much slower than above queries because name isn't indexed.
product = Product.objects.get(name='Neon Shoes')

# this query can have multiple matches which hinders query performance.
product = Product.objects.get(name__startswith='Neon')