I'm still a novice in SQL, and I would really appreciate it if you could help me. How do I get SQL Plan for my query? I have used this for getting a short plan:
EXPLAIN PLAN FOR SELECT * FROM custinfo@smartdev2 s_cs WHERE s_cs.idcust = (SELECT b_cust_id FROM mlb_test.mt_operation_out WHERE id = 1230); SELECT plan_table_output FROM TABLE (DBMS_XPLAN.display ('plan_table', NULL, 'basic'));
But what do i need to use for me to get entire execution plan?
- Oracle Database 18c Enterprise Edition Release 22.214.171.124.0 - Production Version 126.96.36.199.0