MySQL Forums
Forum List  »  General

How should I make text column search faster?
Posted by: Mirabell Stoffen
Date: September 14, 2011 01:06PM

My address column is currently defined as varchar(300) and most of the entries are below 100. Average is 70 characters only.

I have two tasks to accomplish for the address field
i) they should be unique
ii) its search should be fast

There are currently 29 million records and expected to increase by 6 times till December.

I am thinking of creating a hash and putting unique constraint on hash column.

Please suggest me how long hash I should use?
And, Is it really worthwhile to even consider hashing?

If I put index on hash column while unique constraint on address column then there will be two physical indexes or unique constraint will make only virtual index?

Thanks for your attention!

Edited 1 time(s). Last edit at 09/14/2011 01:08PM by Mirabell Stoffen.

Options: ReplyQuote

Written By
How should I make text column search faster?
September 14, 2011 01:06PM

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.