System Design Interview Preparation
Beginner to advanced, with interactive simulators and full design case studies.
Python Full-Stack Interview Preparation
Master backend + frontend questions with real-world cases.
AI/ML Engineer Interview Preparation
ML, deep learning, LLMs, RAG, MLOps and system design - with mock interviews.

Navigate by Range

Django

select_related

Follows single-valued relations (ForeignKey, OneToOne) with a SQL JOIN in the same query.

Pair it with prefetch_related in your answer and say why they differ: a JOIN cannot express a multi-valued relation without row multiplication.

Fetches multi-valued relations (ManyToMany, reverse FK) in a second query and joins them in Python.

One query for a list, then one extra query per row when a related field is accessed.

This term is part of the free Python Full-Stack interview preparation module - browse the full glossary for every definition.

StackScholar is your go-to destination for exploring technology from every angle - from bit to supercomputer.

Occasional email when something substantial ships. No spam, unsubscribe anytime.

Website

Email address