开发者

sql Query Time out error

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜