Tutorial :sql Query Time out error



Question:

I have a table which have 6 million recods,when a fire select query with where condition in that table it is timing out.

How can I make it run, Please help


Solution:1

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.


Solution:2

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


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »