Does anyone know of anything that will tell me what exactly is meant by the various terms used when I run an 'explain analyze' on a query? Some are fairly self explanatory ('seq_scan' vs 'index_scan' for example) but I have no idea what 'materialize' means in this context? Greg