jOOQ doesn't implement indexing. I really suggest learning about those
first. You'll see immediately why jOOQ can't offer help with indexing your
data here (other than creating the CREATE INDEX statements, of course, but
it doesn't matter if you create them via jOOQ or directly in SQL).
If you're
Yes
On Tue, Feb 27, 2024 at 1:33 AM Jason Bennett wrote:
> Appreciate all of the help you provide, Lucas.
>
> I have an Ltree column, which I've generated using the extension jar, so
> it's a proper Ltree type in jOOQ. I would like to run an lquery against
> this column, but jOOQ doesn't seem
Appreciate all of the help you provide, Lucas.
I have an Ltree column, which I've generated using the extension jar, so
it's a proper Ltree type in jOOQ. I would like to run an lquery against
this column, but jOOQ doesn't seem to have that support. Do I need to write
raw SQL here to use the
Thanks Lukas, I'll take closer look at it. I know about it but not familiar
with implementing it.
I meant is there an implementation of indexing in jooq or just study about
it on our cloud servers? If jooq then do you know where to find a resource
for it? As well as connection pools?
But no
Josh,
I mean indexes on your database columns. Do you have an index on relevant
columns of your table? If you don't know about indexing in SQL, I highly
recommend this book (use the "jooq" discount code for 10% off, though it's
only 10 EUR for the PDF version):