If the inner table does not have an index, the database server will compare the cost of building an index on the table to the cost of a sequential scan, and will choose the one with the least cost.
To help ensure that building the initial index has limited impact on users, the common practice is to schedule the first index build process to occur during periods of low reporting usage.