Delay on first open of indexes.



There is a table where has 170000 records, using an index with 3 keys using
and 'order by' in the script. No outer joins (seems simple)!



Question 1

The first query delays about 15 seconds, if we try to execute it again the
same it takes about 1 second. How can we face the first delay?



Question 2

There is an 'order by' statement, where delays too much 1/sec (on the same
query), without the 'order by' it takes less than 1/10sec. There is an index
with this field only, without this index it takes about 2 seconds. May I
reduce this delay in less than 1 second?



The above time is under good cpu server conditions, when the server is
'working' these times take much longer, because of that I try to reduce the
one second.



Thank you in advance.

Dennis





[Non-text portions of this message have been removed]