Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A complex SQL query joining eight tables is experiencing slow performance. The Query Profile indicates that all partitions are being scanned.
What is the most likely cause of this performance issue?
A
Pruning is not being performed efficiently.
B
A huge volume of data is being fetched, with many joins applied.
C
Incorrect joins are being used, leading to scanning and pulling too many records.
D
The columns in the micro-partitions need granular ordering based on the dataset.
