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

[Relishguy]

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..

[Ana C. Dent]

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