I have 2 tables A,B . Can I write a select statement as follows. My query is running slow ( 7000 ms). I have created gin index on text_col and also transactionid is PK on both tables. thanks for your help
B has a transactionid and tsvector columns
A has trasactionid and other columns
I have the query as
select b.col1, b.col2
from
b,a
where b.transactionid=a.transactionid
and b.text_col @@ to_tsquery('SOMETEXT')
Regards
