Which query is better inner join or in???

[slimdave]

Also the number of rows in agg_tbl will grow and shrink rapidly while the application is running. Someone might drag an object onto a chart or destroy a chart and cause the agg_tbl to grow or shrink by anywhere from 100 to 100,000 rows.

You might like to investigate dynamic sampling, in that case.