Bert wrote:
No i didn't defined any indexes for the table, I know the performance
will increase with an index, but this was not my question. My question
furthermore belongs to the access mode of the SQL statement.
Furthermore i do not understand why the Upper function should increase
the performa
No i didn't defined any indexes for the table, I know the performance
will increase with an index, but this was not my question. My question
furthermore belongs to the access mode of the SQL statement.
Furthermore i do not understand why the Upper function should increase
the performance.
The table
You didn't mention version, but 8.1.x has bitmap index scans that might
greatly speed this up...
On Sat, Apr 22, 2006 at 02:34:13PM -0700, [EMAIL PROTECTED] wrote:
> Hi List
> I have maybe an easy question but i do not find an answer, i have this
> SQL query:
>
> SELECT geom,group,production_facs
I can't speak to "the access mode of the SQL statement" but it looks
like the index that you are looking for is an index on an expression,
as shown in:
http://www.postgresql.org/docs/8.0/static/indexes-expressional.html
You probably want a btree on UPPER(municipo), if that is the primary
query me
You have a functional index on UPPER(municipo), right? How large is the table?On 26 Apr 2006 18:26:07 -0700, Bert <
[EMAIL PROTECTED]> wrote:Thanks,But the performance is the same just the formating is more simple.
Greets,Bert---(end of broadcast)---
Thanks,
But the performance is the same just the formating is more simple.
Greets,
Bert
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
SELECT geom, group, production_facs FROM south_america
WHERE UPPER(municipio) IN ('ACRE', 'ADJUNTAS', 'AGUADA');
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi List
> I have maybe an easy question but i do not find an answer, i have this
> SQL query:
>
> SELECT geom,group,prod
Hi List
I have maybe an easy question but i do not find an answer, i have this
SQL query:
SELECT geom,group,production_facs FROM south_america
WHERE municipio = ''
OR municipio = 'ACRE'
OR municipio = 'ADJUNTAS'
