Hello.
You can see these indexes only in the source database and only the source
database can use them.
The linked table simply delegates queries and modification commands to the
source database using its own auto-generated SELECT, INSERT, UPDATE, or
DELETE commands.
--
You received this
I have a table in a database with some indexes. In the GUI (and using
"SELECT * FROM information_schema.indexes") I can see those indexes.
If I then access this table from another database, using the "CREATE LINKED
TABLE" syntax - I can't see those indexes.
Do these indexes exist? Is this a
Thank you Evgenij, that clears up things a lot.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group,
Hello.
AFAIK, this feature was implemented for Apache Ignite that uses query
planner of H2 internally.
However, you can use it in H2 too.
Note that this setting actually affects only the current session and does
not require any privileges (online documentation is not correct), so you
can
In several threads the connection option LAZY_QUERY_EXECUTION=1 has been
mentioned, mostly as an option to improve performance with large result
sets.
I have been looking into the documentation but can not find any more
information about this option. I do understand what the option is about