| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Slow running Query.
Hi, I will do t he following
Try creating function indexes on composed columns you are queryin and tellme
if this improves something
For example you are using as_date in the where column, but you don't have a
index on substr(ca_date,1,4,....
Only to avoid unncesary plsql work
1. instead sum(nvl(column,0)) I'll use nvl(sum(column),0
2. instead of decode use case
 |
 |