Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!newsfeed.telusplanet.net!newsfeed.telus.net!news3.optonline.net!peer02.cox.net!cox.net!p01!fed1read03.POSTED!not-for-mail From: AnaCDent User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.tools Subject: Re: when does sqlplus *not* show the number of rows retrieved? References: <84e6fe3d.0404041119.1bd789a9@posting.google.com> In-Reply-To: <84e6fe3d.0404041119.1bd789a9@posting.google.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 28 Message-ID: Date: Sun, 04 Apr 2004 12:53:48 -0700 NNTP-Posting-Host: 68.7.204.31 X-Complaints-To: abuse@cox.net X-Trace: fed1read03 1081108429 68.7.204.31 (Sun, 04 Apr 2004 15:53:49 EDT) NNTP-Posting-Date: Sun, 04 Apr 2004 15:53:49 EDT Organization: Cox Communications Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:85294 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