You are reviewing the execution plan of an SQL statement. You want to find out which plan operators (POPs) have been exe
Posted: Fri Aug 26, 2022 10:04 am
You are reviewing the execution plan of an SQL statement. You want to find out which plan operators (POPs) have been executed in parallel and for how long each of them has been active.Where can you accomplish this?
A. In SAP NetWeaver: DBA Cockpit (DBACOCKPIT) -> SQL Plan Cache -> EXPLAIN (graphically)
B. In SAP HANA studio: Display the Timeline view via Window -> Show View -> Other ... -> Plan Visualizer -> Timeline
C. In SAP HANA studio: Administration Console -> Performance -> Job Progress
D. In HDB admin -> Performance trace -> Show Column Plans
A. In SAP NetWeaver: DBA Cockpit (DBACOCKPIT) -> SQL Plan Cache -> EXPLAIN (graphically)
B. In SAP HANA studio: Display the Timeline view via Window -> Show View -> Other ... -> Plan Visualizer -> Timeline
C. In SAP HANA studio: Administration Console -> Performance -> Job Progress
D. In HDB admin -> Performance trace -> Show Column Plans