Hi, I often have the following situation: I have a small table with a list of unique IDs and a very large table of events associated with the IDs. I want to perform some aggregation including only events associated with IDs from the small table.
Is there a rule of thumb for whether performing a JOIN on the unique ID is faster or slower than using WHERE id IN (SELECT id FROM small_table...)? Thank you for your advice, Raviv
