On 29.6.2011 22:39, Thomas Mueller wrote:
I'm not sure what the best solution is. Maybe H2 shouldn't allow you to create an index on a BLOB or CLOB column, like most other databases.
That is definately the way to go until someone provides a solution that actually works.
I would assume the no one wants to index BLOBs and for CLOBs you most likely want to use a fulltext index. I am assuming that a regular index or fulltext index does not speed up regex or like queries?
Currently the fulltext index is created for the whole database and there can be only one index / database. Maybe in the future the fulltext index could be made as just one of the possible index types for character based columns?
And then the idea of having indexes on CLOBs could be revisited. - rami -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
