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?

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.