开发者

SQL Full text search with foreign key columns

I have a table (table 1) with couple of column on which i want indexed.

There is also ArticleID 开发者_如何学JAVAcolumn (foreign key), with this id I want to use join to retrieve "articleTitle" from the article Table (table 2), and of curse be able to search in this column.

How do I create this kind of index?

Do I need to index both tables?

and how should i write the select query for that?


You need to create a view and index that

I spent a lot of time on this a while back and the view was the only way I was able to do this.

I also ended up putting everything in 1 column. By this I mean that I added all the text from each column into one column. For example you have a simple table with ID, first, middle, last name columns. In my view I would condense them to 1 column in my view. So for a row of

ID:1 - First Name: Joe - Middle Name: Bob - Last Name: Joe

In the view you would see one column with

1 Joe Bob Joe

This was because I found that some records were not being returned if they were not in ALL columns. Thus by condensing it down to 1 column this problem was eliminated.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜