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.
