Are you using the FullText search or the UBB.threads Internal search? For larger forums we recommend users use the UBB.threads Internal Search.
As for making changes to your database, that is something that you can opt to do for your personal forums, but it is an unsupported change to your database structure.