Density values and joins

When statistics are available on a join column, the total density is used to estimate how many rows match each join key. If the authors table has 5000 rows, and the total density for the city column is .000879, the optimizer estimates that 5000 * .000879 = 4 rows will be returned from authors each time a join on the city column matches a row from the other table.