Strange observation in Explain plan
Hi,
I have a strange thing in this sql. This SQL has join on CRAMER.Port, CRAMER.PortType, CRAMER.EXT_PORT_LIMS. Out of this porttype is a view on porttype_m table. when I take a explain plan of this query the view porttype does not appear in the plan.
explain plan for
SELECT /*+ index (p SYS_C0013339) */ Port.PortID UPK,Port.NAME,Port2PortType TYPE,port2card,portNumber,p.Supplier_Name,p.MTOSI_Name,Port.Alias2
FROM CRAMER.Port, CRAMER.PortType, CRAMER.EXT_PORT_LIMS p
WHERE Port2PortType = PortTypeID AND Port.Portid = p.portid
------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | TempSpc| Cost (%CPU)| Time |
I have a strange thing in this sql. This SQL has join on CRAMER.Port, CRAMER.PortType, CRAMER.EXT_PORT_LIMS. Out of this porttype is a view on porttype_m table. when I take a explain plan of this query the view porttype does not appear in the plan.
explain plan for
SELECT /*+ index (p SYS_C0013339) */ Port.PortID UPK,Port.NAME,Port2PortType TYPE,port2card,portNumber,p.Supplier_Name,p.MTOSI_Name,Port.Alias2
FROM CRAMER.Port, CRAMER.PortType, CRAMER.EXT_PORT_LIMS p
WHERE Port2PortType = PortTypeID AND Port.Portid = p.portid
------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | TempSpc| Cost (%CPU)| Time |
0