As a rule of thumb, if C represents more than ~4% of the table, then a tablescan is more efficient.