Re: [HACKERS] optimizer/planner ideas (repost)

2001-02-06 Thread Tom Lane
Martin Devera <[EMAIL PROTECTED]> writes: > Inner semijoin scans its left input outputting all rows which > has its pair in right input but doesn't duplicate result when > there are duplicates at right. > The WHERE IN(select...), corelated EXISTS and ANY are > converted to it. This semijoin is sim

[HACKERS] optimizer/planner ideas (repost)

2001-02-06 Thread Martin Devera
Hello, probably you remember my crazy idea involving using indexes directly in scans (and resulting speedup). The idea was given to me by experiences with M$SQL (it is yes another M$ soft but its planner is probably better than pg's - no flames please). Because I studied M$ again I've got another