consider this case.
I have a table abc of this sort
a b c d e f g
--|----|---|----|----|----|----|
now say i build a metamorph inverted index like
(a/b/c/d , e, f, g)
the query which i will use would be of the form
sql select ..... where query likep a/b/c/d and e=10 and f=5 and g in ( select g from table 2)
Would this query turn out to be costly in the long run as the table size goes on increasing.
I have a table abc of this sort
a b c d e f g
--|----|---|----|----|----|----|
now say i build a metamorph inverted index like
(a/b/c/d , e, f, g)
the query which i will use would be of the form
sql select ..... where query likep a/b/c/d and e=10 and f=5 and g in ( select g from table 2)
Would this query turn out to be costly in the long run as the table size goes on increasing.