Ray Ontko <[EMAIL PROTECTED]> writes:
> In other words, if I only give one letter, then I might expect
> to get about 1/10 of the table, and a full scan might make sense.
> But the cost should continue to decline as I give longer and longer
> strings, up to the length of the field.  
> Would this be a reasonable improvement to the optimizer?

It's there already; what did you think was making the difference
between W% and WI% ?

                        regards, tom lane



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Reply via email to