Insert into ... select from remote: cardinality hint works driving_site not
Using cardinality hint in subselect seems to work to get work of select done on remote db first
Driving hint and other hints are ignored for dml insert
INSERT /*+ append */
INTO MIG_CGD30_TEST
SELECT /*+ cardinality(ZFD 400000) cardinality(CGD 60000000)*/
TRIM (CGD.NUMCPT) AS NUMCPT, TRIM (ZFD.NUMBDC_NEW) AS NUMBDC
FROM CGD30@DBL_MIG_THALER CGD,
ZFD10@DBL_MIG_THALER ZFD,
EVD01_ADS_DR3W2 EVD
A) why is this working/is this expected behaviour. I thought hints in subselect of insert into where ignored (especially driving_site?)
B) What are the risks that development puts this in their PL/SQL packages , that are executed daily on production ?
Rem. other developers are using bulk collect with driving_site hint, or view on remote site
Alain Lavallée
Edited by: 987903 on 13-feb-2013 11:02