Finding difference in db indexes between versions
search cancel

Finding difference in db indexes between versions

book

Article ID: 277402

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation

Issue/Introduction

Is there a way to find the difference between db indexes between versions?

For instance, is there a list of index changes between v12 and 21? NK_AH_IDNR_bearb was mentioned in the documentation, but are there others that were as well?

Resolution

The best way to check this is to compare the uc_ddl.sql files between versions (using something like a diff or the notepad++ compare plugin).  For example, if upgrading from 12.3 to 21.0 on oracle, look at the following articles (relative to the /db directory):

db\oracle\12.3\uc_ddl.sql
db\oracle\21.0\uc_ddl.sql