On Sun, 5 Nov 2000, Tom Lane wrote: > 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. Actually, it looks like they got a bit smart, and they search for the URL in the url table based on the CRC32 value instead of text ...
- Re: [HACKERS] How to get around LIKE inefficiencies? Bruce Momjian
- Re: [HACKERS] How to get around LIKE inefficiencies... Tom Lane
- Re: [HACKERS] How to get around LIKE inefficien... Philip Warner
- Re: [HACKERS] How to get around LIKE ineffi... Bruce Momjian
- Re: [HACKERS] How to get around LIKE inefficien... Bruce Momjian
- Re: [HACKERS] How to get around LIKE inefficiencies? Philip Warner
- Re: [HACKERS] How to get around LIKE inefficiencies... Tom Lane
- Re: [HACKERS] How to get around LIKE inefficien... Philip Warner
- Re: [HACKERS] How to get around LIKE ineffi... The Hermit Hacker
- Re: [HACKERS] How to get around LIKE in... Tom Lane
- Re: [HACKERS] How to get around LI... The Hermit Hacker
- Re: [HACKERS] How to get around LIKE in... Philip Warner
- Re: [HACKERS] How to get around LI... The Hermit Hacker
- Re: [HACKERS] How to get around LIKE inefficien... Bruce Momjian
- Re: [HACKERS] How to get around LIKE ineffi... Tom Lane
- Re: [HACKERS] How to get around LIKE in... Bruce Momjian
- Re: [HACKERS] How to get around LI... The Hermit Hacker
- Re: [HACKERS] How to get around LI... Bruce Momjian
- Re: [HACKERS] How to get around LI... Tom Lane
- Re: [HACKERS] How to get around LI... Bruce Momjian
- Re: [HACKERS] How to get around LIKE inefficiencies? The Hermit Hacker