So I've got this table with about 4.5 million rows. I have only one index on the primary key which consists of four different fields. Most queries that I do use one of the fields in the primary key, item_id. If I create another index on just that one field, will I get better performance?
Other than that, what can I do to increase performance?
Other than that, what can I do to increase performance?
Facebook
Twitter