We have a requirement as mentioned below:
One table A with 80 million data and 200 columns in the table.One more table K which contains 100 values and 1 column which stores key words.
I need to find all data from table A with a lookup from table K. Within contains predicate I could understand we need to pass <string contant> as second parameter but instead of that I need to pass a table with multiple values as search input.
where contains ( A.col10 , <table B>);
Your help is appreciated.