The query optimiser generates an execution plan, which in this case is a trivial plan that just contains the table scan and select operators. The query execution engine executes that execution plan, requesting every single row in the table from the storage engine, then returning that to the client.