How to create Shareplex hints for faster posting (4266637)

How to create SharePlex hints for faster posting

Post process is slow because it is not using the best index.

Perform the following steps on TARGET:

1. Stop post
sp_ctrl > stop post

2. Change directory to the data subdirectory of SharePlex variable directory

cd $SP_SYS_VARDIR/data

3. Open the hints.SID file and enter the SOURCE owner and name of the TABLE, then enter the TARGET owner and name of the INDEX for table.  (The table name comes from SOURCE but the index name comes from TARGET)

source_owner.source_table_name target_owner.target_table_index

NOTE: If there are too many columns in the table, check the most frequently used column with distinct values by running the below query.

select owner, column_name, num_distinct from dba_tab_columns where table_name=‘XXXXXX’ and owner ='XXXXX'
order by num_distinct

Then select the index on the column and add it to the hints file.

4. Start the post process
sp_ctrl > start post