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

From: Ariel <a_at_a.com>
Date: Thu, 25 Apr 2002 11:35:22 +0100
Message-ID: <aa8ill$olf$1@news.tpi.pl>

> I see a spare letter got into my post - the
> "and index" wasn't intended as an instruction
> to create an index, it should have read
> "disabling an index".

I understand what you mean in previous post. I just try with function based indes on NLSSORT. This behavior looks like query don't use indices, but why?

> First confirm this by re-running the query with
> the two difference settings in turn but:
> set autotrace traceonly explain
> first.

I use application SQLAnalyze from Tuning Pack. on explain plan i see that indices are used on WHERE clause.

I try to remove ORDER BY clause, and this helps... Times of executions equals.

Any further suggestions? What I should to check? Received on Thu Apr 25 2002 - 05:35:22 CDT