I have a community page. It has a search box and a list view to display the search result. Below is the Query I'm building: (It will search in 15M total records)
List<List<sObject>> searchList = [FIND '1234*' IN ALL FIELDS RETURNING Service_visit__c
(Account__r.Name, Account__r.Location__c, OId, Start_Date__c, Address1__c, City__c, State__c, Report_Type__c ORDER BY Start_Date__c DESC LIMIT 200 )
];
Above SOSL is resulting in less record assuming 30 counts.
But When I'm searching with some other string 'abcd 1234*', It's resulting in many records (150 records):
List<List<sObject>> searchList = [FIND 'abcd1234*' IN ALL FIELDS RETURNING Service_visit__c
(Account__r.Name, Account__r.Location__c, OId, Start_Date__c, Address1__c, City__c, State__c, Report_Type__c ORDER BY Start_Date__c DESC LIMIT 200 )
];