Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: select like...not using index
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
- Cc: pgsql-hackers(at)postgresql(dot)org, "PgSql-Win32" <pgsql-hackers-win32(at)postgresql(dot)org>
- Subject: Re: select like...not using index
- Date: Sat, 29 May 2004 00:35:27 -0400
- Message-id: <14637(dot)1085805327(at)sss(dot)pgh(dot)pa(dot)us>
"Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> writes: > Sometime between yesterday and today queries in the form of > "select * from t where t.f like 'k%'" have been broken so that they > never use the index (on win32, not sure about others). Not here ... and I've seen no commits that I'd have thought would affect that. Check for local configuration changes. regards, tom lane
- References:
- select like...not using index
- From: Merlin Moncure
- select like...not using index
- Prev by Date: Re: nested transaction patch build?
- Next by Date: Re: could not locate my own executable path
- Previous by thread: Re: [HACKERS] select like...not using index
- Next by thread: Loggin on WIN32
- Indexes: