Hi Kevin
I have already, in an earlier stage looked at tyour suggestion.
In my query I ask for the top 100 results in a database that holds up to 10 million records.
Using a select query that uses mentioned Where clause would only give me the top 100 results of the men 500 m (by far the fastest combination)
Without knowing if it is possible I was thinking about creating 2 arrays:
1: arrDistance(500, 1000, 1500)
2: arrGender(Male. female)
In the execution phase (or how to call it) the arrDistance (500) gets combined with both male and female
After that the 1000 gets combined to male and female and as last combinations 1500 - male and 1500 - female
Am I thinking way out of line, or is there a way to get this working?
Hein