Can you elucidate the nuances of relational algebra operators, such as selection, projection, join, and aggregation, in the context of table manipulation and query optimization, particularly with respect to query complexity and execution plan generation?