Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
select /*+ RULE */ l.nominal_region,l.nominal_county, s.weekno,s.year,s.obs_dt,s.data_source from sub s,location l where s.loc_id=l.loc_id and s.proj_id = 'GBW' and s.weekno is not null and l.nominal_region is not null Plan SELECT STATEMENT HINT: RULE 5 NESTED LOOPS 2 TABLE ACCESS BY INDEX ROWID BTOWATCH.SUB 1 INDEX RANGE SCAN NON-UNIQUE BTOWATCH.INDX_SUB_PROJID 4 TABLE ACCESS BY INDEX ROWID BTOWATCH.LOCATION 3 INDEX UNIQUE SCAN UNIQUE BTOWATCH.PK_LOCATION Without RULE hint: Plan SELECT STATEMENT CHOOSECost: 12,885 Bytes: 196,571,034 Cardinality: 2,978,349 3 HASH JOIN Cost: 12,885 Bytes: 196,571,034 Cardinality: 2,978,349 1 TABLE ACCESS FULL BTOWATCH.LOCATION Cost: 518 Bytes: 10,589,376 Cardinality: 378,192 2 TABLE ACCESS FULL BTOWATCH.SUB Cost: 9,886 Bytes: 112,586,514 Cardinality: 2,962,803