Configuring Indexing

Important:You must create the required indexes before continuing with subsequent configuration and external connection steps.

Table indexes improve database performance and can help optimize slow queries. Creating these indexes will boost the performance of the Flexera One app’s data transformation processes. The following tables have one or more fields that require indexing. The field label and field name are provided, below, to clearly identify which fields to index.

Tables	Table Labels	Field Names	Field Labels
cmdb_model	Product Model	x_fls_flexeraone_technopedia_id	Technopedia ID
cmdb_sam_sw_install	Software Installation	x_fls_flexeraone_flexera_unique_id	Flexera Unique ID
		discovery_source	Discovery source
samp_sw_product	Software Product	x_fls_flexeraone_technopedia_id	Technopedia ID
samp_sw_publisher	Software Publisher	x_fls_flexeraone_technopedia_id	Technopedia ID
sam_sw_product_lifecycle	Software Product Lifecycle	x_fls_flexeraone_technopedia_id	Technopedia ID
		lifecycle_phase	Lifecycle phase
sys_object_source	Source	id	ID
cmdb_ci_computer	Computer	discovery_source	Discovery source
cmdb_ci_netgear	Network Gear	discovery_source	Discovery source
cmdb_ci_network_adapter	Network Adapter	discovery_source	Discovery source

Tip:Depending on the size of the table, the time it takes to complete indexing can range from seconds to hours to days.

To configure indexing

1.

Navigate to System Definition > Tables & Columns.

2.

For each table with a field that requires indexing, perform the following steps:

a.

In the Table Names list, locate the table and click its name.

b.

In the Index creator pane, select the fields you want to include in the index.

c.

Click Create Index.

d.

Set your notification preference.

Either provide an email address to be notified when the indexing is completed or choose Do not notify me.

e.

Click OK.

When the indexes have been created, continue the configuration by checking all of the Import properties described in Setting Import Properties.