DEA-C02 Performance Optimization — All Questions With Answers

Query Profile shows: 
- Table Scan: 85%
- Local Disk Spilling: 5%
- Remote Disk Spilling: 0%
- Network: 10%

SELECT * FROM sales WHERE region = 'EMEA' AND sale_date >= '2023-01-01';

{
  "Node": "Join",
  "Status": "Success",
  "Statistics": {
    "PartitionsScanned": 4500,
    "PartitionsTotal": 4500,
    "SpillageToLocalDisk": "150GB",
    "SpillageToRemoteDisk": "1.2TB"
  }
}

SELECT * FROM TABLE(INFORMATION_SCHEMA.AUTOMATIC_CLUSTERING_HISTORY(
  TABLE_NAME => 'SALES_DATA',
  START_TIME => DATEADD(H, -12, CURRENT_TIMESTAMP())));