W dniu 2012-12-12 14:15, un_spoken pisze: > SELECT > T.ID_TASK, L.LATITUDE, L.LONGITUDE > FROM > TASK T > INNER JOIN > LOCATION L > ON > T.IDLOCATION = L.ID_LOCATION > WHERE > T.IDSHEDULE IN (8169797) Sorry, can't help much but it would be interesting to see tthe subsequent times of finding SELECT T.ID_TASK FROM TASK T WHERE T.IDSHEDULE IN (8169797)
with and without index, but first : do you have a copy of working database for testing ? Did you recomputed index statistics ? Just my two cents Bogusław
