Integer comparison will be faster compared to string comparison. Is there any change in the performance if there are more distinct values or less distinct values.
A field with less distinct values will be better for performance than a field with more distinct values. For this reason it's recommended to split timestamp fields into a date and a time field for large tables. Low cardinality fields take up less memory and can be searched and sorted faster.
