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?