I have a table with close to 1 million records. My program imports new records from a text file selected by the user into this table. The table has a field listing the name of the file that each record came from. Is there an efficient way to search the table to see if a file already exists i.e. see if the file has already been imported. I'm currently using a simple select statement that searches for the filename in question but that has become incredibly slow.

Kris H.