Re: [PERFORM] select count(*) from anIntColumn where int_value = 0; is very slow

[David Teran]

Hi,

Is your int_value data type int4? If not then use "... from 
job_property
where int_value = '0'"
Indexes are used only if datatypes matches.

tried those variations already. Strange enough, after dropping and 
recreating the index everything worked fine.

regards David

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]