Subject Re: error: key size too big for index
Author Aage Johansen
vsvadlenka wrote:
> ...
> I have compounded idex for quickly finding out, if such record
> exists, for performance reason. Maybe three separate indexes would
> do that job?

You will have to try it out on your data. If one index has high
selectivity you may not need the other indexes - it may be (sufficiently)
fast. I would try with only one index at first. If you are not satisfied,
move on ...


Regards,
Aage J.