Storing user search keywords
If the keys repeat frequently, create a second table

CREATE TABLE Key_tbl (key_id INT, key VARCHAR(&lt;&gt;))


and reference the first table with this, while inserting just look up the key and insert the key_id in SearchKeyword