|
indraneelkurane
Starting Member
India
1 Posts |
 Posted - 02/01/2012 : 07:25:29
|
We have a table with 150000 records. It has a primary key on 3 columns and a index on 5 columns.
When a select query is executed on this table usully it takes 6 seconds to execute but some time it takes more than a 60 seconds and then 'Query Time out' message is reported.
This problem is seen intermittently.
What could be the solution for this? or What approach I should follow to derive proper solution?
Indraneel |
|
Query Time Out
