[Home] [Help]
select /*+ no_cartesian(mmd) no_cartesian(mex) ordered use_nl(o mmd) */
u.name, mmd.kln, mmd.mix, mmd.mnm, mex.xix, mex.xln
from sys.x$joxmex mex, sys.x$joxmmd mmd, sys.user$ u
where mmd.own = u.user#
and mmd.mix != -1
and mmd.mix = mex.mix
and mmd.obn = mex.obn
SELECT /*+ NO_CARTESIAN(MMD) NO_CARTESIAN(MEX) ORDERED USE_NL(O MMD) */
U.NAME
, MMD.KLN
, MMD.MIX
, MMD.MNM
, MEX.XIX
, MEX.XLN
FROM SYS.X$JOXMEX MEX
, SYS.X$JOXMMD MMD
, SYS.USER$ U
WHERE MMD.OWN = U.USER#
AND MMD.MIX != -1
AND MMD.MIX = MEX.MIX
AND MMD.OBN = MEX.OBN
|
|
|
|