Another option would be to create persisted indexed computed columns for each segment. However load test before deploying to production for crud operation performance degradation due to index overhead. Be certain to allow for addition storage overhead for the indexes and remember to alter any stored procedures accessing the table with the required set parameters, the same required for an indexed view.