Hi. I am working with FEDSQL and date. I have a table of approx. 40 million rows where I want to do the following. If I run this without the and date >= date'2021-04-01' then it runs between 2.5 and 3 seconds (resultset is approx 650k rows). If I add the and date >= date'2021-04-01' the same query runs in just over 25 seconds. giving a slightly smaller result set. If i run with out the date filter and does the subset for the in a separate sas data step the subsequent datastep runs in apprx. 0.4 seconds. I created a track. Number is 7613313278 Do i do something wrong? Can anybody please explain why? proc fedsql sessref=casauto;
drop table casuser.WellProfileDays force;
create table casuser.WellProfileDays
as select
wellbore,
date,
Plant_cd,
Complex_cd,
Facility_nm,
bucket,
min(oil) as oil,
min(gas) as gas,
min(BOE) as boe
from std_production.STF_all_details_hist
where stf_case=&stf_case
and date >= date'2021-04-01'
group by
wellbore,
date,
Plant_cd,
Complex_cd,
Facility_nm,
bucket;
quit;
... View more