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
- You haven't got any indexes on the columns in your where condition
- Your where condition/whole query is inefficient.
Please post your SQL
精彩评论