Multiple choice technology databases

while making query in a partitioned table which one we should use .

  1. explicit reference to partitions

  2. use the partition key in filter condition

  3. query will automatically decide the partition

  4. All of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Using the partition key in filter conditions enables partition pruning, where the optimizer automatically accesses only relevant partitions. Explicit partition references make code rigid and break when partitions change. The query optimizer automatically selects partitions based on the partition key in WHERE clauses.

Keep practicing — related questions