regarding indexes

Post Reply
gaurav.shetti
Posts: 119
Joined: Fri Feb 27, 2009 9:09 am

regarding indexes

Post by 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.
Post Reply