Subject | Re: error: key size too big for index |
---|---|
Author | Aage Johansen |
Post date | 2002-08-15T17:47:56Z |
vsvadlenka wrote:
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.
> ...You will have to try it out on your data. If one index has high
> I have compounded idex for quickly finding out, if such record
> exists, for performance reason. Maybe three separate indexes would
> do that job?
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.