Other Factors That Influence Query Response Time

The following factors can influence query response time:

• Collection of table statistics

• Memory allocation

• Sorting

• Presence of large object (LOB) columns in your base table

• Partitioning

• Parallelism

• The number term expansions in your query

  See Also: “Frequently Asked Questions About Query Performance”