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)
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It based on your field access. The files which you use more ti get filter out data create index on that field.