Evaluate the following SQL statement used to create the PRODUCTS table: Which statement is true regarding this command?()
- A、It executes successfully but partition pruning cannot happen for this partition key.
- B、It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
- C、It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
- D、It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
正确答案:D
答案解析:有
微信扫一扫手机做题