I don't know how anyone else feels about this, as I don't think I've
seen this ever suggested, but my ideal would be a way to configure the
database to recognize specific queries and to have a way of influencing
its plan choice for that query. I'm intentionally wording that last part
vaguely,
I'm wondering whether columns, in the select list of a view that is used
in a join, which are not used either as join criteria or in the select
list of the overall query, effect the performance of the query.
In other words supposed I define a view something like
CREATE view MyView AS SELECT