View Issue Details

IDProjectCategoryView StatusLast Update
0003833SymmetricDSImprovementpublic2019-03-14 08:48
ReportermmichalekAssigned Tommichalek 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.0 
Target Version3.10.0Fixed in Version3.10.0 
Summary0003833: Improve performance and accuracy of DDL retrieval of Oracle Indexes (3.10)
DescriptionThe "readIndecies" phase of loading a table on Oracle was found to take 1-2 seconds at times during Oracle testing. The slowness appears to be related to a NOT IN/subselect clause in the SQL reading the indexes.

The change here is to issue 2 separate queries to filter out the PK indexes from the list. This seems to show significant performance improvement (now readIndecies is taking 1-10 milliseconds instead of over 1 second).

Also changed this code to use ALL_INDEXES instead of USER_INDEXES so there is better chance for visibility on Indexes that aren't owned by the current user.
TagsNo tags attached.

Relationships

related to 0003823 closedmmichalek Improve performance and accuracy of DDL retrieval of Oracle Indexes 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2018-12-17 10:48 mmichalek New Issue
2018-12-17 10:48 mmichalek Status new => assigned
2018-12-17 10:48 mmichalek Assigned To => mmichalek
2018-12-17 10:48 mmichalek Issue generated from: 0003823
2018-12-17 10:48 mmichalek Relationship added related to 0003823
2018-12-17 10:48 mmichalek Status assigned => resolved
2018-12-17 10:48 mmichalek Resolution open => fixed
2018-12-17 10:48 mmichalek Fixed in Version => 3.10.0
2019-03-14 08:48 admin Status resolved => closed