Dear experts,
I have the following query:
select * from notafiscal where numeroctc like POA%34345;
Prefix is normally 3 characters, suffix varyies.
Is Postgresql 9.0.4 able to use an BTREE index on notafiscal.numeroctc to
execute this query?
Should I create GIST index or something else to speed up the query?
Thanks,
Edson Carlos Ericksson Richter
SimKorp Infomática Ltda
Fone:
(51) 3366-7964
Celular:
(51) 8585-0796
Embedded Image
<http://www.simkorp.com.br/> www.simkorp.com.br