Re: cannot make indexes on long varchar?

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

Re: cannot make indexes on long varchar?

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 . On Sat, 1 Dec 2018 at 14:48, Alex O'Ree wrote: > Is there a particular

Re: cannot make indexes on long varchar?

I would think it's because long columns will not work anway (half page size). "Indexes Indexes are not supported for columns defined on CLOB, BLOB, LONG VARCHAR, and XML data types. If the length of the key columns in an index is larger than half the page size of the index, creating an

cannot make indexes on long varchar?

Is there a particular reason we can't do indexes on long varchar columns?