SF-PD2 Performance — All Questions With Answers

{
  "query": "SELECT Id, Name FROM Account WHERE CreatedDate > 2023-01-01T00:00:00Z",
  "limit": 50000,
  "status": "NON_SELECTIVE_QUERY_EXCEPTION"
}

{
  "query": "SELECT Id, (SELECT Id FROM Contacts) FROM Account WHERE Id IN :accountIds",
  "limit": 50000,
  "type": "Apex"
}

SELECT Id, Name FROM Account WHERE CreatedDate >= 2023-01-01T00:00:00Z AND Custom_External_Id__c = 'EXT-9988'

[
  {
    "cardinality": 1500,
    "fields": ["Custom_Key__c"],
    "leadingOperationType": "Index",
    "notes": [],
    "relativeCost": 0.15,
    "sobjectCardinality": 1000000,
    "sobjectType": "Application__c"
  },
  {
    "cardinality": 900000,
    "fields": [],
    "leadingOperationType": "TableScan",
    "notes": [],
    "relativeCost": 2.45,
    "sobjectCardinality": 1000000,
    "sobjectType": "Application__c"
  }
]

SELECT Id, Name FROM Account WHERE Id IN (SELECT AccountId FROM Opportunity WHERE Amount > 100000)

{
  "apex_cpu_time": "9999ms",
  "limit": "10000ms",
  "status": "CPU_TIME_LIMIT_EXCEEDED"
}

SELECT Name, Account.Name FROM Contact WHERE Account.Industry = 'Technology'

14:22:05.054 (54201234)|CUMULATIVE_LIMIT_USAGE
14:22:05.054 (54201234)|LIMIT_USAGE_FOR_NS|(default)|
  Number of SOQL queries: 15 out of 100
  Number of query rows: 1200 out of 50000
  Maximum CPU time: 10005 out of 10000 *CLOSE TO LIMIT*
  Maximum heap size: 2500 out of 6000000