From cdd230d62899455cc07ba1caf68387fb834d5bd2 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 5 Jun 2001 17:13:52 +0000 Subject: Improve planning of OR indexscan plans: for quals like WHERE (a = 1 or a = 2) and b = 42 and an index on (a,b), include the clause b = 42 in the indexquals generated for each arm of the OR clause. Essentially this is an index- driven conversion from CNF to DNF. Implementation is a bit klugy, but better than not exploiting the extra quals at all ... --- src/include/optimizer/paths.h | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) (limited to 'src/include/optimizer/paths.h') diff --git a/src/include/optimizer/paths.h b/src/include/optimizer/paths.h index 39afe74d2ad..f676e61d1f7 100644 --- a/src/include/optimizer/paths.h +++ b/src/include/optimizer/paths.h @@ -8,7 +8,7 @@ * Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: paths.h,v 1.53 2001/05/20 20:28:20 tgl Exp $ + * $Id: paths.h,v 1.54 2001/06/05 17:13:51 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -47,8 +47,7 @@ extern List *expand_indexqual_conditions(List *indexquals); * orindxpath.c * additional routines for indexable OR clauses */ -extern void create_or_index_paths(Query *root, RelOptInfo *rel, - List *clauses); +extern void create_or_index_paths(Query *root, RelOptInfo *rel); /* * tidpath.h -- cgit v1.2.3