removed switching off static table optimization for subselects (SCRUM , pre-commit  to be able merge with temporary table fix)