I have a column called nickname and have created index for it.
create index test_idx on test_table using btree (nickname);
My query is,
select * from test_table where nickname ilike '%pga%';
test_table is having around 100k records. when I'm doing explain, i am getting some cost which is same as before creating the index. Why is that.?
(using Postgresql 9.2)
nickname column is character varying(100)