Michael Fuhr wrote:
On Thu, Oct 07, 2004 at 09:08:18PM -0700, Dennis Gearon wrote:
About regular views, how does that speed things up, other than the initial
SQL interpretation of the view not needing to be done?
I didn't mean to imply that views would speed things up -- I was
merely suggesting them as an alternative to your "flattened table"
if part of its purpose would be to simplify queries. You might
want to perform some experiments to see if the performance gains
from a materialized view are worth the extra complexity.
I'll do the experiments! It'll probably be about 6 months out. I plan ahead :-)
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
