Not true, you can index such columns but it does not make sense using standard as Mikael explained. For such follow Using the luceneSupport optional tool <https://db.apache.org/derby/docs/10.14/tools/rtoolsoptlucene.html>.
On Sat, 1 Dec 2018 at 14:48, Alex O'Ree <[email protected]> wrote: > Is there a particular reason we can't do indexes on long varchar columns? > -- Peter Ondruška -- kaibo, s.r.o., ID 28435036, registered with the commercial register administered by the Municipal Court in Prague, section C, file 141269. Registered office and postal address: kaibo, s.r.o., Kališnická 379/10, Prague 3, 130 00, Czech Republic. https://www.kaibo.eu <https://www.kaibo.eu>
