db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@gmail.com>
Subject Re: cannot make indexes on long varchar?
Date Sat, 01 Dec 2018 17:29:22 GMT
On 12/1/18 5:48 AM, Alex O'Ree wrote:
> Is there a particular reason we can't do indexes on long varchar columns?

You can use VARCHAR(32672) instead of LONG VARCHAR. Then you can create 
indexes on these columns.

Hope this helps,

-Rick


Mime
View raw message