Multiple choice technology

True/False: Data needs to be partitioned on same key before using the lookup local functions.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Lookup local functions work on partitioned data where the partition key matches the lookup condition. If data isn't partitioned on the lookup key, each partition would need to search the entire lookup cache, defeating the purpose of local lookup optimization.

Keep practicing — related questions