Index DB in KNIME

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
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?


Ok… Thank you very much.

1 Like

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