My MDB FILE uses Oracle linked table, i use a linked text file which has the keys to filter the oracle linked table. when i build query using these 2 tables, it executes for long time i.e hang out. how could be this resolved?

Table 1: linked text file
Table 2: linked Oracle DB table

Query: uses both the above table

Result: hangs out

expecting suggestion