regarding indexes

[gaurav.shetti]

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.

[John]

That may depend on how many records are returned in the sub-select, and how many records are likely to match the rest of the query.