good morning, see if you can help me. I'm using sql developer,and oracle data miner, and I have observed, as the sql code doubles, and the execution lasts twice as long,I send you the images and the code that is repeated, this does not happen to me alone, but also to my colleagues.please can you help me. Very thanks
the code that repeats begins on line 06 up to 48(/* Start of sql for node: CUSTOMER */)then starts at 68 to 110
/* SQL Deployed by Oracle SQL Developer 4.1.2.20.64 from Node "Join", Workflow "dhf", Project "bigdatalite", Connection "moviedemo" on Sep 27, 2017 */
ALTER SESSION set "_optimizer_reuse_cost_annotations" = false;
ALTER SESSION set NLS_NUMERIC_CHARACTERS = ".," ;
--ALTER SESSION FOR OPTIMIZER
WITH
/* Start of sql for node: CUSTOMER */
"N$10001" as (select "CUSTOMER"."AGE",
"CUSTOMER"."CITY",
"CUSTOMER"."CITY_ID",
"CUSTOMER"."COMMUTE_DISTANCE",
"CUSTOMER"."COUNTRY",
"CUSTOMER"."COUNTRY_CODE",
"CUSTOMER"."COUNTRY_ID",
"CUSTOMER"."CREDIT_BALANCE",
"CUSTOMER"."CUST_ID",
"CUSTOMER"."EDUCATION",
"CUSTOMER"."EMAIL",
"CUSTOMER"."FIRST_NAME",
"CUSTOMER"."FULL_TIME",
"CUSTOMER"."GENDER",
"CUSTOMER"."HOUSEHOLD_SIZE",
"CUSTOMER"."INCOME",
"CUSTOMER"."INCOME_LEVEL",
"CUSTOMER"."INSUFF_FUNDS_INCIDENTS",
"CUSTOMER"."JOB_TYPE",
"CUSTOMER"."LAST_NAME",
"CUSTOMER"."LATE_MORT_RENT_PMTS",
"CUSTOMER"."MARITAL_STATUS",
"CUSTOMER"."MORTGAGE_AMT",
"CUSTOMER"."NUM_CARS",
"CUSTOMER"."NUM_MORTGAGES",
"CUSTOMER"."PET",
"CUSTOMER"."POSTAL_CODE",
"CUSTOMER"."PROMOTION_RESPONSE",
"CUSTOMER"."RENT_OWN",
"CUSTOMER"."SEG",
"CUSTOMER"."STATE_PROVINCE",
"CUSTOMER"."STATE_PROVINCE_ID",
"CUSTOMER"."STREET_ADDRESS",
"CUSTOMER"."USERNAME",
"CUSTOMER"."WORK_EXPERIENCE",
"CUSTOMER"."YRS_CURRENT_EMPLOYER",
"CUSTOMER"."YRS_CUSTOMER",
"CUSTOMER"."YRS_RESIDENCE",
"CUSTOMER"."CONTINENT",
"CUSTOMER"."CONTINENT_ID"
from "MOVIEDEMO"."CUSTOMER" )
/* End of sql for node: CUSTOMER */
,
/* Start of sql for node: SQL Query */
"CUSTOMER_N$10001" as (SELECT * FROM "N$10001"),
"N$10002" as (SELECT
"CUSTOMER_N$10001"."AGE",
"CUSTOMER_N$10001"."CITY",
"CUSTOMER_N$10001"."CITY_ID",
"CUSTOMER_N$10001"."COMMUTE_DISTANCE"
FROM "CUSTOMER_N$10001")
/* End of sql for node: SQL Query */
,
/* Start of sql for node: SQL Query 1 */
"SQL Query_N$10002" as (SELECT * FROM "N$10002"),
"N$10004" as (SELECT "SQL Query_N$10002"."AGE",
"SQL Query_N$10002"."CITY",
"SQL Query_N$10002"."CITY_ID"
FROM "SQL Query_N$10002")
/* End of sql for node: SQL Query 1 */
,
/* Start of sql for node: CUSTOMER */
"N$10001" as (select "CUSTOMER"."AGE",
"CUSTOMER"."CITY",
"CUSTOMER"."CITY_ID",
"CUSTOMER"."COMMUTE_DISTANCE",
"CUSTOMER"."COUNTRY",
"CUSTOMER"."COUNTRY_CODE",
"CUSTOMER"."COUNTRY_ID",
"CUSTOMER"."CREDIT_BALANCE",
"CUSTOMER"."CUST_ID",
"CUSTOMER"."EDUCATION",
"CUSTOMER"."EMAIL",
"CUSTOMER"."FIRST_NAME",
"CUSTOMER"."FULL_TIME",
"CUSTOMER"."GENDER",
"CUSTOMER"."HOUSEHOLD_SIZE",
"CUSTOMER"."INCOME",
"CUSTOMER"."INCOME_LEVEL",
"CUSTOMER"."INSUFF_FUNDS_INCIDENTS",
"CUSTOMER"."JOB_TYPE",
"CUSTOMER"."LAST_NAME",
"CUSTOMER"."LATE_MORT_RENT_PMTS",
"CUSTOMER"."MARITAL_STATUS",
"CUSTOMER"."MORTGAGE_AMT",
"CUSTOMER"."NUM_CARS",
"CUSTOMER"."NUM_MORTGAGES",
"CUSTOMER"."PET",
"CUSTOMER"."POSTAL_CODE",
"CUSTOMER"."PROMOTION_RESPONSE",
"CUSTOMER"."RENT_OWN",
"CUSTOMER"."SEG",
"CUSTOMER"."STATE_PROVINCE",
"CUSTOMER"."STATE_PROVINCE_ID",
"CUSTOMER"."STREET_ADDRESS",
"CUSTOMER"."USERNAME",
"CUSTOMER"."WORK_EXPERIENCE",
"CUSTOMER"."YRS_CURRENT_EMPLOYER",
"CUSTOMER"."YRS_CUSTOMER",
"CUSTOMER"."YRS_RESIDENCE",
"CUSTOMER"."CONTINENT",
"CUSTOMER"."CONTINENT_ID"
from "MOVIEDEMO"."CUSTOMER" )
/* End of sql for node: CUSTOMER */
,
/* Start of sql for node: SQL Query */
"CUSTOMER_N$10001" as (SELECT * FROM "N$10001"),
"N$10002" as (SELECT
"CUSTOMER_N$10001"."AGE",
"CUSTOMER_N$10001"."CITY",
"CUSTOMER_N$10001"."CITY_ID",
"CUSTOMER_N$10001"."COMMUTE_DISTANCE"
FROM "CUSTOMER_N$10001")
/* End of sql for node: SQL Query */
,
/* Start of sql for node: Join */
"N$10003" as (SELECT
"SQL Query"."AGE"
, "SQL Query"."CITY"
, "SQL Query"."CITY_ID"
, "SQL Query"."COMMUTE_DISTANCE"
, "SQL Query 1"."AGE" "AGE1"
, "SQL Query 1"."CITY" "CITY1"
, "SQL Query 1"."CITY_ID" "CITY_ID1"
FROM
"N$10002" "SQL Query"
LEFT OUTER JOIN "N$10004" "SQL Query 1"
ON "SQL Query"."AGE" = "SQL Query 1"."AGE"
)
/* End of sql for node: Join */
select * from "N$10003";