Full text performance vs keyword tables.
So I have a customer that stores a database of about 2million records. One of the fields in this database is a company name. In order to search this field, they split the field up into individual words, and create a new record in a different table for each word, indexed to the company id. This results in about 8 million records.
For example: Table one has a record with a company id & name of "1","Mysql AB Inc". In the second table, there are 3 records:
"1", Mysql"
"2", "AB"
"3", "Inc"
As this process require a weekly rebuild, and the current process is a mess, I was curious about using Full Text Searching and whether or not that would represent any performance hit or benefit.
Joe
Subject
Views
Written By
Posted
Full text performance vs keyword tables.
4867
September 11, 2008 11:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.