Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help needed in tuning query
Try add column: contentintid into your index
'IDX_T_CONTENT_ALL'((contenttypeintid, statusintid, to_char(adddate))
Will make Oracle just index scan and return data (without table scan
using rowid). One more change in index :
> to_char(adddate)
change to to_char(adddate),'YYYYMMDD')
or create new index:
(contenttypeintid, statusintid, to_char(adddate),'YYYYMMDD'),
contentintid)
Hope this helps
Vinh
Received on Wed Aug 04 2004 - 21:33:37 CDT