Is a multi-column index slower than a single-column index?
I have a primary key on (A, B) where A is a varchar(30) and B is a INT.
Would queries searching on A run faster if I had an index on A instead?
I understand the leftmost prefix rule, but I'm curious if a multi-column
key/index performs worse than a single-column key/index due to the key
being longer.
No comments:
Post a Comment