MySQL Forums
Forum List  »  Performance

Re: String match is too slow in huge table
Posted by: KimSeong Loh
Date: December 27, 2004 11:54PM

How long is your name and surname field?
The index gets very big if the length is long.

Maybe you can try to index only a prefix of the fields.
For example, index only the first 5 chars, or any number that makes sense to you.
create index namesur on sisben (name1(5),surname1(5));

Also, you can do an EXPLAIN to make sure the index is actually used.

Options: ReplyQuote

Written By
Re: String match is too slow in huge table
December 27, 2004 11:54PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.