Re: System statistics in Oracle 10.2

From: <frank.van.bortel_at_gmail.com>
Date: 5 Oct 2006 08:15:21 -0700
Message-ID: <1160061320.929429.316270@k70g2000cwa.googlegroups.com>

Ana Ribeiro schreef:

> Hi,
> I have a question concerning SYSTEM statistics generation. When I ran
> the following query in Oracle 10.1, the response time was 1 second and
> the execution plan showed me that the right indexes were being used.
>
> select id from indObj where lower(attrname) = 'name' and
> id in (select id from classificationObject
> where contains(descriptorid, '12610') > 0

you have Oracle Text indexes. These may be the source of your findings. Received on Thu Oct 05 2006 - 10:15:21 CDT