simulated join before using index

freshness in computed by computing join result