Re: [PERFORM] Good/Bad query plans based on text criteria

2010-04-14 Thread Tom Lane
JmH writes: > I am struggling to understand why for certain criteria that i supply for a > query alters the the query plan. In my "good" case i can see that an index > is used, in my bad case where i only change the text value of the criteria, > but not the criteria itslef (ie change/add the condi

[PERFORM] Good/Bad query plans based on text criteria

2010-04-14 Thread JmH
Hello, I am struggling to understand why for certain criteria that i supply for a query alters the the query plan. In my "good" case i can see that an index is used, in my bad case where i only change the text value of the criteria, but not the criteria itslef (ie change/add the conditions) a hbit