On 2012/05/24 07:37, Alex Schaft wrote: > You are selecting a record based on the value of data_id and > thold_enabled, but don't have an index on either? Add an index for both. > If data_id is unique, then you would only need an index on that. > > Alex >
On second thought, an index on thold_enabled won't mean much I think, so either leave it off or create an index on data_id plus thold_enabled. Someone more knowledgeable may correct me. Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql