Yes, you can expect a performance boost.
I recently did that for one of the databases I look after and the difference was phenomenal: over 99% of the searches the users are more than 100 times faster. This table also has a lot of inserts and there is no slowdown that I can detect. I don't know about bulk-inserts except that importing a full dump on the development box is no slower that I've noticed.
There is a very big "but": it is *not* as simple as re-indexing and altering the SQL. There is a mind-set to searching that has to change, too. Using LIKE is very simplistic and brute-force. Using MATCH is very like using an Internet search engine, even more so in Boolean mode. Remember to train your users.
Wade.
Subject
Views
Written By
Posted
8689
March 15, 2005 04:17AM
Yes, you can expect a performance boost.
3660
March 16, 2005 05:09PM
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.