Sharkie wrote:
<snip>
> Can anyone explain it??? How can a simple date function cause so much
> slow down?
> The difference in time execution is tremendous.
> Any other ideas on what's causing all the recursive calls and db block
> gets?
>
> Note that the content table has a compound index of
> (contenttypeintid, statusintid, to_char(adddate))
> No index exist on upper(searchstring) since it's a varchar(4000) field
> and I get:
> ORA-01450: maximum key length (3218) exceeded
some quick thoughts...
- implicit date conversions happening?
- function based indices?
try this: 'ELECTRONIC%'
instead of this: '%ELECTRONIC%' (if possible)
Received on Wed Aug 04 2004 - 13:20:52 CDT
