We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

full text index

lespbaj
lespbaj asked
on
Medium Priority
223 Views
Last Modified: 2012-05-11
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)
Comment
Watch Question

SQL SERVER EXPERT
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT

Commented:
It based on your field access. The files which you use more ti get filter out data create index on that field.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.