You need to use the Index fields in where condition in SOQL if you have more than 200000  records 

If you're running a trigger on objects that have more than 200,000 records, it's possible that you'll receive the error, "System.QueryException: Non-selective query against large object type." We'll go over the a few possible fixes. 


1. You may find that the query in question needs to be more selective in the WHERE clause. According to the Salesforce standards & best practices - the where clause needs to subset 10% or less of the data.
2. A custom index on the field.
3. A possible quick fix may be to make the field in question an external ID. Since external IDs are indexed automatically, this will create the index and may solve the problem.

In Classic, go to Setup -> Create -> Objects then click the Object name. 
In LEX, go to Setup -> Object Manager  then Object name.
Then, edit field name and check the box External ID.

NOTE: If this does help your query performance, we recommend that you still log a case with support to implement a custom index in it's place. This is not a long term solution for performance improvements and has other designed use cases.
Read our Make SOQL query selective help article for more information on indexing.

https://help.salesforce.com/articleView?id=000002493&type=1

 

public class InvoiceTriggerHelper {
        public static void updateInvoice(List<cma_Invoice__c> lstInvoice){
            System.debug('lstInvoice'+lstInvoice);
            
            Map<Id, List<cma_Invoice__c>> acctIdinvoiceListMap = new Map<Id, List<cma_Invoice__c>>();
            Set<Id> acctIds = new Set<Id>();
            List<cma_Invoice__c> invoiceList = new List<cma_Invoice__c>();
            for(cma_Invoice__c invoice : lstInvoice){
                system.debug('invoice.cma_Account__r.id--->'+invoice.cma_Account__c);
                if(invoice.cma_Account__c != null){
                    acctIds.add(invoice.cma_Account__c);
                }
            }
            system.debug('acctids--->'+acctIds);
            if(acctIds.size() > 0){
        invoiceList = [SELECT sic_Invoice_Amount_EUR_current_year__c, sic_Invoice_Volume_Tons_current_year__c, cma_Account__c FROM cma_Invoice__c WHERE cma_Account__c IN : acctIds AND cma_Account__c!=NULL ];
        
        for(cma_Invoice__c invoice : invoiceList){
            if(!acctIdinvoiceListMap.containsKey(invoice.cma_Account__c)){
                acctIdinvoiceListMap.put(invoice.cma_Account__c, new List<cma_Invoice__c>());
            }
            acctIdinvoiceListMap.get(invoice.cma_Account__c).add(invoice);
        }

        List<Account> acctList = new List<Account>();
        acctList = [SELECT sic_Actuals_YTD_turnover_EUR__c, sic_Actuals_YTD_Volume_Tons__c FROM Account WHERE Id IN: acctIds];
        for(Account acct : acctList){
            List<cma_Invoice__c> tempinvoiceList = new List<cma_Invoice__c>();
            tempinvoiceList = acctIdinvoiceListMap.get(acct.Id);
            Double totalturnover = 0;
            Double totalVolume = 0;
            if(tempinvoiceList!=null && !tempinvoiceList.isEmpty()){
                for(cma_Invoice__c invoice : tempinvoiceList){
                    if(invoice.sic_Invoice_Amount_EUR_current_year__c != null){
                      totalturnover += invoice.sic_Invoice_Amount_EUR_current_year__c;
                    }
                    if(invoice.sic_Invoice_Volume_Tons_current_year__c !=null){
                        totalVolume += invoice.sic_Invoice_Volume_Tons_current_year__c;
                    }
                }
            }
            acct.sic_Actuals_YTD_turnover_EUR__c = totalturnover;
            acct.sic_Actuals_YTD_Volume_Tons__c = totalVolume;
        }
        update acctList;
            }
        }
    
   
    }