Data search from massive database

Hello
I have a large data file (about 100 million records) in a sql server database
Please tell me what is the best way to search this file?
I mean, how can I search the information in my file with the highest speed
I use the following method to search the file that I have, which is slow and I want to increase the speed. Please suggest a better way to search.
The method I use

@alex1368 this method will be very slow since you seem to download the whole (?) database to KNIME and then do a search. Maybe it would be better to upload the list from excel also to the database and then do the join there or convert information from your local file into Flow Variables and let the load run on the SQL Server.

Maybe take a look at these examples

More on KNIME and SQL you can find here:

2 Likes