Re: Performance of indexing on varchar columns without specific length

Hello! The actual VARCHAR lengths means less than you think. Instead, you can supply a correct INLINE_SIZE when creating this index: https://ignite.apache.org/docs/latest/SQL/sql-tuning#increasing-index-inline-size https://ignite.apache.org/docs/latest/SQL/indexes#configuring-index-inline-size By

Performance of indexing on varchar columns without specific length

Hi, A table has two varchar columns, one column created with specific column length and other created without any specific length as shown below: CREATE TABLE person (id LONG PRIMARY KEY, name VARCHAR(64), last_name VARCHAR) Can we create index on varchar columns without any specific length? In