Which type of query optimization technique focuses on reducing the number of rows to be scanned in a database query?

  • Indexing
  • Partitioning
  • Predicate Pushdown
  • Projection Pushdown
Predicate Pushdown is a query optimization technique that focuses on reducing the number of rows to be scanned in a database query. It involves pushing down the predicates (conditions) from the outer query into the inner query, thereby filtering the rows early in the query execution process. This helps in improving query performance by minimizing the amount of data that needs to be processed.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *