开发者

sql Query Time out error

开发者 https://www.devze.com 2022-12-24 13:35 出处:网络
I have a table which have 6 million recods,when a fir开发者_JS百科e select query with where conditionin that table it is timing out.

I have a table which have 6 million recods,when a fir开发者_JS百科e select query with where condition in that table it is timing out.

How can I make it run, Please help


Assuming there aren't any indexes, add an index to the appropriate column(s).

If you need a more detailed answer, you need to provide more information, including the table schema, the query, and the indexes already against the table.


Either

  1. You haven't got any indexes on the columns in your where condition
  2. Your where condition/whole query is inefficient.

Please post your SQL

0

精彩评论

暂无评论...
验证码 换一张
取 消