The Hermit Hacker <[EMAIL PROTECTED]> writes: > On Mon, 6 Nov 2000, Philip Warner wrote: >> At 21:59 5/11/00 -0500, Tom Lane wrote: >>>> Looks like a great kluge to me ;-) >> >> Hmph. I prefer to think of it as a 'user-defined optimizer hint'. ;-} > Except, if we are telling it to get rid of using the index, may as well > get rid of it altogether, as updates/inserts would be slowed down by > having to update that too ... Sure --- but do you have any other query types where the index *is* useful? If so, Philip's idea will let you suppress use of the index for just this one kind of query. regards, tom lane
- Re: [HACKERS] How to get around LIKE inefficiencies? Tom Lane
- Re: [HACKERS] How to get around LIKE inefficiencies... Bruce Momjian
- Re: [HACKERS] How to get around LIKE inefficien... Tom Lane
- Re: [HACKERS] How to get around LIKE ineffi... Philip Warner
- Re: [HACKERS] How to get around LIKE in... Bruce Momjian
- Re: [HACKERS] How to get around LIKE ineffi... Bruce Momjian
- Re: [HACKERS] How to get around LIKE inefficiencies... Philip Warner
- Re: [HACKERS] How to get around LIKE inefficien... Tom Lane
- Re: [HACKERS] How to get around LIKE ineffi... Philip Warner
- Re: [HACKERS] How to get around LIKE in... The Hermit Hacker
- Re: [HACKERS] How to get around LI... Tom Lane
- Re: [HACKERS] How to get aroun... The Hermit Hacker
- Re: [HACKERS] How to get around LI... Philip Warner
- Re: [HACKERS] How to get aroun... The Hermit Hacker
- Re: [HACKERS] How to get around LIKE ineffi... Bruce Momjian
- Re: [HACKERS] How to get around LIKE in... Tom Lane
- Re: [HACKERS] How to get around LI... Bruce Momjian
- Re: [HACKERS] How to get aroun... The Hermit Hacker
- Re: [HACKERS] How to get aroun... Bruce Momjian
- Re: [HACKERS] How to get aroun... Tom Lane
- Re: [HACKERS] How to get aroun... Bruce Momjian