We have a Backup log DE with Data spreading for 4yrs with around 600M records.

When i trying to Query a DE with filters like date ,status..the query fails with the timeout error. I tried to use the filter and also the random split still it doesnt work. filter and randomsplit didnt create any segemented DE from it.

i did check the log DE and there are no null values for subscriber or emailaddress.

tried with query studio,automation query and automation activity..all the cases it fails.

The query is select count subscriberkey,eventdate from [Log_DE] where year(eventdate) = ‘2023’.

The query is select count subscriberkey,eventdate from [Log_DE] where year(eventdate) = ‘2023’ and status =’Active’

the query fails with the timeout error.

Can you please help me with any trick to query this DE with 600M records.

I logged a case with Salesforce but they are telling we need to do some custom coding in the org as its a huge load on the servers and it will be billed.

Thank you