View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0003833||SymmetricDS||Improvement||public||2018-12-17 10:48||2018-12-17 10:48|
|Target Version||3.10.0||Fixed in Version||3.10.0|
|Summary||0003833: Improve performance and accuracy of DDL retrieval of Oracle Indexes (3.10)|
|Description||The "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.
|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|