Oracle Text Reference Release 9.0.1 Part Number A90121-01 |
|
CTX_QUERY Package , 3 of 7
Returns the number of hits for the specified query. You can call COUNT_HITS in exact or estimate mode. Exact mode returns the exact number of hits for the query. Estimate mode returns an upper-bound estimate but runs faster than exact mode.
CTX_QUERY.COUNT_HITS ( index_name IN VARCHAR2, text_query IN VARCHAR2, exact IN BOOLEAN DEFAULT TRUE, part_name IN VARCHAR2 DEFAULT NULL ) RETURN NUMBER;
Specify the index name.
Specify the query.
Specify TRUE for an exact count. Specify FALSE for an upper-bound estimate. Specifying FALSE returns a less accurate number but runs faster.
Specify the name of the index partition to query.
If the query contains structured criteria, you should use SELECT COUNT(*).
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|