Index DB in KNIME

upload_2022_04_08_17_27_27_031
How to understand which field is indexed in KNIME

Hi @Nuke_Attokurov ,
I guess it depends on your DB Management System. In my case (MariaDB) the workflow is straightforward
immagine
The first node creates a connection to a MariaDB server, the second hosts a query like this one
SHOW INDEX FROM database_name.table_name
and here’s the result (in the example: table_name=siti)


Is that what you need?

2 Likes

Ok… Thank you very much.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.