If I have a relation and create a multicolumn index on all the attributes, would the index be bigger than the relation itself? would it be more efficient to keep the relation ordered on all the attribute if I have a lot of additions? I have relations that are only incremental in time and they are huge, i.e. exponential in the size of the rest of the database. The problem arises when I have to check for existence of a tuple in those type of relations.
Regards, tzahi. WARNING TO SPAMMERS: see at http://members.lycos.co.uk/my2nis/spamwarning.html ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly