On Tue, 2006-06-06 at 18:51 +0900, ITAGAKI Takahiro wrote: > Indexes are used for two purpose, for selection and for ordering, but EXPLAIN > shows them as 'Index Scan' in both cases. This patch changes EXPLAIN output of > Index Scan without Index Cond to 'Index Full Scan'.
I like it. Will that test always hold true? Even if it is currently true, perhaps there should be a code comment to say we rely on that behaviour later to make EXPLAIN function correctly? We definitely need some code comments somewhere. Perhaps we should call it 'Ordered Scan' so that it is completely different from 'Index Scan'? -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org