I have the following problem. I am developing an application using Oracle Lite. One of queries have a strange behavior.
If my computer is just switched on, the query runs 10 seconds (which is unacceptably slow). Next time I run the query it runs 1 second. All other queries run normally.
The query is very simple. something like this:
from gg_price_items pi
where pi.CANV_CODE = 'ROTT'
and pi.CANV_EDITION = 2006
and pi.SECTION_CODE = '01';
The table has approximately 2000000 records. All necessary indexes exist. Query returns approximately 5000 records.
I use Oracle Lite 10.2.0.2. (This problem also exists for the version 10.2.0.1)
Can I improve the performance of this query ?