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 default it's 10, and some of those bytes are used for length, etc. Regards, -- Ilya Kasnacheev пт, 6 нояб. 2020 г. в 21:04, Shravya Nethula < shravya.neth...@aline-consulting.com>: > 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 the > above scenario, can we create index on last_name column? > And while creating index on those columns, will there be any performance > difference on these columns? > > > Regards, > > Shravya Nethula, > > BigData Developer, > > > Hyderabad. > >
