subject:"\[PERFORM\] >= forces row compare and not index elements compare when possible"

Re: [PERFORM] >= forces row compare and not index elements compare when possible

2006-01-14 Thread Tom Lane

"Bernard Dhooghe" <[EMAIL PROTECTED]> writes: > So >= (or <=) is not optimized against an index where it could be. Work in progress... regards, tom lane ---(end of broadcast)--- TIP 5: don't forget to increase your free spac

[PERFORM] >= forces row compare and not index elements compare when possible

2006-01-13 Thread Bernard Dhooghe

Suppose a table with structure: Table "public.t4" Column | Type | Modifiers +---+--- c1 | character(10) | not null c2 | character(6) | not null c3 | date | not null c4 | character(30) | c5 | numeric(10,2) | not null Indexes: