Can you post the queries and plans where the automatically generated view is much slow than your view? I can see that your view does not join on acs_objects.