What step will im the performance of queries executed against an external table?

Question

Options

• APartition the external table.
• BShorten the names of the source files.
• CConvert the source files' character encoding to UTF-8.
• DUse an internal stage instead of an external stage to store the source files.

• A
  95% (56)
• C
  3% (2)
• D
  2% (1)

Explanation

Partitioning an external table is a technique that improves the performance of queries executed against the table by reducing the amount of data scanned. Partitioning an external table involves creating one or more partition columns that define how the table is logically divided into subsets of data based on the values in those columns. The partition columns can be derived from the file metadata (such as file name, path, size, or modification time) or from the file content (such as a column value or a JSON attribute). Partitioning an external table allows the query optimizer to prune the files that do not match the query predicates, thus avoiding unnecessary data scanning

No community discussion yet for this question.