I am new to custom settings.
My assumption is Custom Settings are part of application cache as such querying against custom settings do not count against SOQL limit.
This is my code snippet (executed from developer console).
Combinations__c is a custom setting.
String q='Creative'; String t='Dealer'; String a='Expand'; String sa='Included'; List<Combinations__c> sb = [SELECT ID FROM Combinations__c WHERE Queue__c=:q AND Type__c=:t AND Area__c=:a AND Sub_Area__c=:sa]; System.debug(sb.size());
This is my log as shown below.As you can see it is firing one SOQL query.
I am confused :(
I believed querying against Custom Settings do not count against limit.
Can someone explain why a SOQL is fired and is counted against the limit of 100 even when I am querying against custom settings ?