I wonder if using multiple fields to perform a filter (used in a Xbrowse with the headers search gets) the order is important.
Let say that I want foling fields filtered :
Index is on Name : filter like Name...+Color++++Size (filter setting)
Name : Test
Color : Blue
size : Large
Second option is the field Color is before the name in the browse, the filter will be :
Color...+Name....+Size (filter setting)
In the first case, the filter's first field is a index field and I think that it will go direct to a position of the name
In the second case the corlor has no index and I think that ALL record will be processed and then the rest of the filter.
I hope my question make sence )))
Witch is best ?