By default, Oracle Text optimizes queries for throughput. This results in queries returning all rows in shortest time possible.
However, in many cases, especially in a Web application scenario, queries must be optimized for response time, when you are only interested in obtaining the first few hits of a potentially large hitlist in the shortest time possible.
The following sections describe some ways to optimize
CONTAINS queries for response time: