Optimizing Queries for Response Time

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:

• 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 STAGE_ITAB Option of CONTEXT Index