FROM table query can be optimized by enabling the optimize_functions_to_subcolumns setting. With optimize_functions_to_subcolumns = 1 the function reads only null subcolumn instead of reading and p... cardinalities. Returns float number from 0 to 1 – the closer to zero, the more strings are similar to each other. If the constant substring or substring is more than 32Kb, throws an exception. If s...