sql - Efficeint way to check if 35K + rows are present in table X having 700000+ rows? -

I have 35K + records in a flat file (called column A) I have to check that these records are already in table X (700000+ are recorded)

• The column A table index does not have an indexed column. I do not have any column in the flat file that is indexed in x.

  - I can not use these operators in SELECT because it is not a viable option for 35+ records (expensive and 1K limit) - all records are the same pattern I tried to match pattern in SELECT using LIKE operator but it is very inefficient. (Number of records with similar pattern in X is 120000+) - I do not have the table privilege to include in the new table and subtracting etc.

  I'm new to Oracle if this question is naive. Besides, I searched for similar questions and could not get the answer for the non-indexed column.

  Can anyone help me?

  Does the meaning of flat files have a text file like CSV or TSV? If this is just a text file, then load it into the database. Maybe you can create a temporary table for this job. You can use the following question:

   Select from x * * (c1, c2, ...) in (c1, c2, ... to a);