Hi all,

 

I have to provide a pretty standard query that should return every row where the NAME attribute begins with a specific string. The type of the NAME column is varchar. I do have an index for this column. One would think that Postgres will use the index to look up the matches, but apparently that is not the case. It performs a full table scan.  My query looks something like this:

 

SELECT * FROM table WHERE name LIKE ‘smith%’;

 

Does anyone know a way to “force” the optimizer to utilize the index? Is there perhaps another way of doing this?

 

Thanks for the help!

Jozsef

Reply via email to