I am using a MySQL database and perform many select like these:
SELECT MyField FROM MyTable WHERE MyKey = 'some_value';
The purpose is to retrieve a field a value if the corresponding row exists.
MyKey is the only key in the table and it is indexed.
My question is: is there any benefit or drawback to adding
LIMIT 0,1 to my statement?