When is a PRIMARY KEY (PK) table constraint evaluated during an INSERT statement into the table?
Which two file formats are valid for external tables?
Which date time format is used to capture history activities?
The nzhostbackup command backs up which directory by default?
Consider a scenario where a customer has a FACT_SALES table with a column zip_code with data type char(5| They frequently restrict on this column, but the query is very inefficient.
What is the correct way to optimize this query without modifying the column?