IBM
P2090-050 · Question #100
What is the limitation on join types with floating-point data types?
The correct answer is D. The system cannot perform a fast hash join on a floating point data type, but instead must. See the full explanation below for the reasoning.
Question
What is the limitation on join types with floating-point data types?
Options
- AThe system does not have a limitation on floating-point data types.
- BThe system cannot perform any type of join on floating-point data types.
- CThe system cannot perform a fast sort merge join on a floating point data type, but instead must
- DThe system cannot perform a fast hash join on a floating point data type, but instead must
How the community answered
(29 responses)- A3% (1)
- B3% (1)
- C10% (3)
- D83% (24)
Community Discussion
No community discussion yet for this question.