Re: This same query - diffrerent time to execute...

From: Ariel <a_at_a.com>
Date: Thu, 25 Apr 2002 10:17:25 +0100
Message-ID: <aa8e3g$b5u$1@news.tpi.pl>

> It would be appropriate to tell us how much difference -
> 3 seconds to 15 minutes is worth looking at
> 0.5 seconds to 0.51 seconds is not.

OK.
On "ansi" time is ~5 sec.
On "binary" time is ~1.5 sec.

> First step in your investigation - check the execution path.
> It is possible that by forcing Oracle to do ANSI comparison
> instead of binary comparison you are effectively disabling
> and index which helps to accelerate the BINARY path.

I use NLS_LANGUAGE=Polish
and when I set NLS_COMP=binary I get strange results on results using "special - polish" letters.

I try to use
CREATE INDEX pl_i1 ON table(NLSSORT(col, 'NLS_SORT=Polish')), but does'nt help this. Received on Thu Apr 25 2002 - 04:17:25 CDT