I want to create a table which will contain approx 20,000 records of three fields each. Two of the fields will contain numeric values.
I want to be able to issue a SELECT BETWEEN command. One record will be returned.
I anticipate that certain records will be returned more frequently than others. Will I gain any performance increase by placing these records near the start of the table? (I'm assuming that MySQL reads a table sequentially).