Explanation:
Dynamic File Pruning significantly improves join performance by pruning (skipping) files in a large fact table based on filter criteria derived from a joined dimension table at runtime.
Ultimate access to all questions.
A
To skip scanning irrelevant files in a large table based on a filter applied to a joined smaller table.
B
To automatically delete files unaccessed for 90 days.
C
To compress small files during query runtime.
D
To remove duplicate columns from a SELECT statement.
No comments yet.