how to do fast lookup for big table
what are the posisbilities to do fast lookup for big table table (300MM) to check the existence of matched record in smaller table (20MM)? one thing that comes to my mind is that smaller table could be IOT. it could work for one pass over big table filtering out records that match and insert with nologging into another table those that don't match.
are there other ways of doing such lookups?
thank you