Optimizing Queries for Response Time

By default, Oracle Text optimizes queries for throughput so that queries return all rows in the shortest time possible.

However, in many cases, especially in a web application, you must optimize queries for response time, because 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:

• Other Factors that Influence Query Response Time

• Improved Response Time with FIRST_ROWS(n) Hint for ORDER BY Queries

• Improved Response Time Using the DOMAIN_INDEX_SORT Hint

• Improved Response Time using Local Partitioned CONTEXT Index

• Improved Response Time with Local Partitioned Index for Order by Score

• Improved Response Time with Query Filter Cache

• Improved Response Time using BIG_IO Option of CONTEXT Index

• Improved Response Time using SEPARATE_OFFSETS Option of CONTEXT Index

• Improved Response Time Using the STAGE_ITAB, STAGE_ITAB_MAX_ROWS, and STAGE_ITAB_PARALLEL Options of CONTEXT Index