T
Thomas Mercer-Hursh
Guest
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.
Continue reading...
Continue reading...