Generate Text Index on CMDB_CI and CMDB_CI_PRINTER

[rebecca75]

I've triggered the 'Generate Text Index' on cmdb_ci and cmdb_ci_printer tables to fulfill a request to have the ability to 'for text' search on these tables. I have two questions, one I did not receive the text index complete email (outbox in our STAGE env.). Second, is there any performance impacts kicking off the 'Generate Text Index' on these two fields during business hours?

[Alex North]

Hi Rebecca,

Did you manage to check and see whether the text index processor job was still running? The notification email would be queued up once the table had finished being indexed? You could also see the status for a given text index by going to "System Definition > Text Indexes". Text indexing is managed per hierarchy, so you'd be looking for the "cmdb" table in the list.

Alex

[Matt Small1]

Alex,

I wanted to confirm do you recommend or do you have your cmdb set up for text_indexing?  How many record are in your cmdb/cmdb_ci tables?  I am leaning to turn on text indexing for the cmdb to allow for better querying and user experience but am concerned about performace.  SN support recommends not to enable but it appears that is not necessarily a performance killer.

thanks,

Matt Small

[rebecca75]

Thank you Alex for all your help! I have everything working as expected!!!