[GENERAL] Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?

[Edson Carlos Ericksson Richter]

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

 

<<image001.jpg>>

smime.p7s
Description: S/MIME cryptographic signature