Re: [PERFORM] Getting query plan alternatives from query planner?

2014-04-14 Thread Eric Schwarzenbach
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,

[PERFORM] view columns and performance

2010-07-30 Thread Eric Schwarzenbach
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