Alex Thank you for the advice.
Probably, we will put index (key) on both columns. Thanks, Yu Alex Schaft さんは書きました: >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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql