Re: [GENERAL] Question about index usage

[Guido Neitzer]

On 07.03.2006, at 12:09 Uhr, chris smith wrote:

Try without the quotes:

select id from dga_dienstleister where plz in (45257, 45259);

Same result, second index is used.

What is the table structure for dga_dienstleister ?

For the relevant column:



Thanks,
cug

--
PharmaLine, Essen, GERMANY
Software and Database Development

plz | character varying(256) | not null

smime.p7s
Description: S/MIME cryptographic signature