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