Re: when does sqlplus *not* show the number of rows retrieved?

Relishguy wrote:
> I have been doing some performance tests with Oracle Text. Basically I
> am trying to determine which query options return the desired data and
> how long do they take (e.g. set timing on).
>
> For some reason, some Oracle Text query options cause sqlplus to *not*
> display the number of records returned. Of course, I have used an
> alternate method to determine this, but I am wondering how I
> "disabled" this.
>
> The cases (I have found so far) are:
>
> 1. NEAR((a,b),15,false) - display records with the 2 terms within 15
> words of each other
> 2. a > 70 - display records where the score for this term is greater
> than 70
>
> Both of these are arguments to the CONTAINS clause.
>
> TIA.
>
> Regards..

IRRC, if the number of rows returned is 5 or less, then no "feedback" count is displayed. The threshold is a settable value or can be turned off always by
set feedback 0 Received on Sun Apr 04 2004 - 21:53:48 CEST