With 23c/23ai , find ANY data in ANY table easily!

In 23c/23ai , it now take just a few lines of code to enable a Google-like search across your entire database!
Follow me!
blog: connor-mcdonal...
twitter: / connor_mc_d
Subscribe for new tech videos every week
Other social media channels here: linktr.ee/connor
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla
#sql #database

[@Elfcheg]

What a nice feature! I guess there are scheduler jobs associated with this facility to update index in background.

[@DatabaseDude]

I suspect it will be the same processing as "sync on commit" for text indexes, ie, to my knowledge there is not a scheduler job because that's a fairly heavy start/stop process

[@berndeckenfels]

Is the json data really constructed from the index.. I.e. the fülltest index does not only contain reverse tokens but full data (I.e. indexsize is more that data size?) or does it just transparently query the rows to construct a virtual complete result document?

[@DatabaseDude]

the "getdocument" API will build a full json. The index is a "standard" json index, ie, we section the data and extract tokens and the like

[@berndeckenfels]

@@DatabaseDude in any case a great feature for those full text search problems!