If the column has
a unique index: no, it’s no faster
a non-unique index: maybe, because it will prevent sending any additional rows beyond the first matched, if any exist
no index: sometimes
- if 1 or more rows match the query, yes, because the full table scan will be halted after the first row is matched.
- if no rows match the query, no, because it will need to complete a full table scan