hi all,
I have a table table_A (id serial,prefix varchar),for example.
now I want to get the id of "johnsmith"'s prefix match table_A.prefix,so I do select id from table_A where 'johnsmith' like prefix||'%' ,the table_A is very large so I would like to make index. create table_A_index on table_A(prefix)
I try to explain analyze,but it doesn't work ,it use seq scan.
I try another index. drop index table_A_index; create table_A_index on table_A(prefix varchar_pattern_ops); it doesn't work,too.
thanks
ps:I have another table table_B would use table_B.prefix=
table_A.prefix.so how can I create the index?
yours, Tony