J
jmls
Guest
It's not just a word index search.. You can search for all records containing a key value pair, like customer= foo You can't do that with a word index On 15 Jun 2014 17:41, "Thomas Mercer-Hursh" bounce-tamhas@community.progress.com wrote: RE: json datatype Reply by Thomas Mercer-Hursh Indexing was one of the things that occurred to me as a possible plus, but I was interested in a real use case since I am not sure what kind of indexing one would apply to such a potentially arbitrary string. Is it word indexing? I can see it being highly desirable to word index a CLOB, but I don't know that making a separate JSON datatype would necessarily make that easier and I can think of a lot of uses for it besides that. For uses like saving context across AppServer calls and such, I would think one would actually want separate fields to contain the user id, session id, etc. and those are easy to index. So, the use case is still a bit fuzzy to me beyond the general attraction of a word index on any CLOB. Stop receiving emails on this subject. Flag this post as spam/abuse.
Continue reading...
Continue reading...