In general, I've seen a comment that varchar columns don't make efficient index columns. However, I have a customer material table which has two main columns, one an integer and the other a varchar. The integer is the customer ID and the varchar is the material description. When a range of materials is required, it would generally be each customer's materials in alphabetic order. Would a clustered index on description, customer ID be a good or a bad idea? Thanks in advance.