Database Seek vs Scan

I don’t know if this is a typo or I just don’t understand.

Under “What Can You DO?” it says " This would use a seek (assuming customers table has an index on customer_id" . Wouldn’t it need to be city that has the index?

https://www.codecademy.com/paths/computer-science/tracks/cspath-databases/modules/cspath-how-do-i-make-sure-my-database-stays-fast/articles/seek-vs-scan

I just hit this same section in my path. I think it has to be a typo, but would appreciate someone with more experience commenting as well.

This topic was automatically closed 41 days after the last reply. New replies are no longer allowed.