DB Query Reader index

[jpages]

Hello,

When I load a table from a postrgesql database, and this table have a index created on that database, the index is loaded as well and used on the workflow joins?

Thanks

[ipazin]

Hello @jpages,

if by “load a table” you mean that table is read into KNIME then no. Otherwise all database manipulation using DB nodes is performed on database level and in that case index is utilized.

Br,
Ivan

[jpages]

Thanks for the quick response.
Just for confirmation, is there any way to use the database index with a readed table in KNIME? Or am I obligated to use DB nodes?

[ipazin]

Hello @jpages,

interesting idea but unfortunately no. You have to stick with DB nodes.

Br,
Ivan