Re: Performance of indexing on varchar columns without specific length

[Ilya Kasnacheev]

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.
>
>

Performance of indexing on varchar columns without specific length

[Shravya Nethula]

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,

[cid:5ffa4fac-72f1-4b29-a0f6-4750deb51d8f]

Hyderabad.