Tuning based on SQL diagrams
Since this is a non-equality criterion, adding an index on the ORDERSTATUS column will not help because SQL Server will not use it. I also review data skew when I notice a status or flag type of column being used in a query. For this column, here are a list of values and the number of rows that contain the value: