Link to home
Start Free TrialLog in
Avatar of lespbaj
lespbaj

asked on

full text index

First of all I would like to beg your perdon for my english.

My question is about full text index.

from the performance point of view, is it better one catalog per table or one catalog for all the tables?
what in your opinion should be the limits in terms of the number of fields per table than must be include in then index in order to keep the date base performance? (I have a table with 232 fields and around 72 varchar and text fields that can be included and I dont know if is a good idea to include all of them)
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It based on your field access. The files which you use more ti get filter out data create index on that field.