Hi Memsql Community,
I can read in the docs the maximum columns in an index is 32,
But what is the maximum size in KB/ Width of the indexed columns?
in many other RDBMS:
mysql - 767 bytes of a single column (can be increased with some special config)
mssql - 900 bytes for a clustered index. 1,700 for a nonclustered index. for memory-optimized tables 2500 bytes for a nonclustered index
so whats the total & single column size that will be indexed.
example: would 3 TEXT columns (65,535 bytes) would be fully indexed.