@@ to_tsquery help

Started by akp geekabout 15 years ago1 messagesgeneral
Jump to latest
#1akp geek
akpgeek@gmail.com

Hi all -

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