![[Featured Image]: A person uses a laptop to search for index seek versus index scan to learn more about database development and management.](https://images.ctfassets.net/wp1lcwdav1p1/4WvNPBHAbUWHeVUiQagctE/850bb53e4aaeb9ecdb5c4d2b83effbdf/GettyImages-2177606480__2_.jpg?w=330&h=216&q=60&fit=fill&f=faces&fm=jpg&fl=progressive)
Understanding Index Seek vs. Index Scan in Databases
Learn how database engines use index seeks and index scans to retrieve data efficiently. Explore how the query optimizer chooses between them.
November 24, 2025
Article
Coursera Staff
Editorial Team
Bio
Coursera’s editorial team is comprised of highly experienced professional editors, writers, and fact-checkers. Our articles are deeply researched and thoroughly reviewed to ensure we are providing trustworthy information and advice for any topic. We understand that taking the next step in your education or career can raise questions. We are here to provide actionable, reliable, and relevant answers so you can achieve your goals.
![[Featured Image] A computer programmer types code to guide the AI in generating content.](https://images.ctfassets.net/wp1lcwdav1p1/EvQRdjv53GIDCjat5gnVn/cf5fcb3bb8ba6ba559e77433a678e13d/GettyImages-2163867921.jpg?w=330&h=216&q=60&fit=fill&f=faces&fm=jpg&fl=progressive)
![[Featured Image] An SQL specialist teaches a professional in a work environment, discussing ways to improve SQL skills.](https://images.ctfassets.net/wp1lcwdav1p1/7EZutVBmBRPniid6Xe8SRX/7a15ec9851a36b285a8c7df574d87e13/GettyImages-1533018004__1_.jpg?w=330&h=216&q=60&fit=fill&f=faces&fm=jpg&fl=progressive)
![[Featured Image] Python professionals in a work environment discussing how to improve Python coding skills while reviewing code on their computers.](https://images.ctfassets.net/wp1lcwdav1p1/1qwzM5qOJPbPBgnfK5JTXd/288eff4cc5555c5e71bc3113e1cef76e/GettyImages-2204328676.jpg?w=330&h=216&q=60&fit=fill&f=faces&fm=jpg&fl=progressive)
![[Featured Image] A professional leading a meeting on strategy with their team in a modern office, discussing key project management skills.](https://images.ctfassets.net/wp1lcwdav1p1/4RceQd6Fhn0p6WinuVUQqY/c444711879d1aab8c79dbb3af4f9ec8c/GettyImages-2159048996.jpg?w=330&h=216&q=60&fit=fill&f=faces&fm=jpg&fl=progressive)
![[Featured Image] Professionals in a work environment discussing how to improve Java programming skills while reviewing code on their computers.](https://images.ctfassets.net/wp1lcwdav1p1/3vgMBUnVrKTdfShVbvrl0R/53fa552a59f6b33a5bcd4fb4d500f1cc/GettyImages-1425175413__1_.jpg?w=330&h=216&q=60&fit=fill&f=faces&fm=jpg&fl=progressive)