Using synchronous SOQL performed via Apex or the Salesforce REST API, you can only filter records based on the index fields defined when you created the big object. In other words, it is not possible to filter by the Time__c, Position__c, or Milliseconds__c fields. Records are returned in the order defined by the index fields, defining an ORDER BY clause that does not match the index fields sequence and sorting is not supported.
The order in which you defined the index fields is very important as it determines the constraints of your filter criteria. It will help in the following examples to think about the index fields as being defined from left to right, where the left-most field is RaceId__c, and the ...
