Re: [postgis-users] Why won’t my SELECT query use the INDEX?

2014-12-17 Thread CABO
-12-16 17:23 GMT+01:00 Andy Colson a...@squeakycode.netmailto:a...@squeakycode.net: On 12/16/2014 9:18 AM, Casper Børgesen (CABO) wrote: This seems like one of the most asked questions in the PostgreSQL world, but I guess I haven’t understood all the answers yet: Why won’t my SELECT query use

[postgis-users] Why won’t my SELECT query use the INDEX?

2014-12-16 Thread CABO
This seems like one of the most asked questions in the PostgreSQL world, but I guess I haven’t understood all the answers yet: Why won’t my SELECT query use the INDEX I have created for it? I have a table with about 18mio rows. My SELECT statement looks like this: SELECT