Table Filtering Using Big List
How can I effectively filter a huge table using another big list?

Just JOIN the big table to list.
Just make sure your list is a table format:

External Table
Global Temporary Table
APEX Collection (for APEX apps)
an SQL collection (variable)

PL/SQL collection (18c+)