Hi ,

This is first time I am trying to do development on POSTGRES.
I am trying to build multi-relational indices. So that when user enters keyword he will get in which relation in which tuple this keyword occured. This is also known as inverted indices. I am thinking of adding Index at database level which will kepp track of all keywords. Another approach is to create a dummy table which will store information of all words in database. And add index on this tacle. Can any one guide me regarding how feasiable these method are? And if feasiable which one is better?

Regard's,
~Ajay

---------------------------(end of broadcast)---------------------------
TIP 1: 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

Reply via email to