thanks a lot Claudio for advice .
i m going to modify and try it again
thks

david..


Sorry for the previous mail, I've just realized the original mail had a
date
from year 2009 though it was sent on December 11th, causing it to be in
the
top of my inbox after several days away.

Anyway, if you still need this, you can modify the last part of your
query:

from

AND
TO_NUMBER(TO_CHAR(RUBRIQUE_QUANTITE_JOURNALIERE.QTEJR_GASDAY,'YYYY')) =
2006)

to

AND
RUBRIQUE_QUANTITE_JOURNALIERE.QTEJR_GASDAY between TO_DATE('2006/01/01
00:00:00','YYYY/MM/DD HH24:MI:SS') and TO_DATE('2006/12/31
23:59:59','YYYY/MM/DD HH24:MI:SS')


That way you can have index access on your QTEJR_GASDAY field.
Anyway, I believe this would be of insignificant help though you can try.
I would also recommend that you have a single index based on the following
fields:
QTEJR_GASDAY, QTEJR_CSVCREATIONDATE, MSG_NUMERO, PROC_TYPE, PTR_CODE,
RUBRQTE_NUMERO (I believe that for better performance QTEJR_GASDAY should
be
your first field in the index, and the others can go in any order).
I hope this helps.
Regards,

--Claudio

Oracle LazyDBA home page