View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0003823||SymmetricDS||Improvement||public||2018-12-07 15:51||2018-12-07 16:00|
|Target Version||3.9.16||Fixed in Version||3.9.16|
|Summary||0003823: Improve performance and accuracy of DDL retrieval of Oracle Indexes|
|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-07 15:51||mmichalek||New Issue|
|2018-12-07 15:51||mmichalek||Status||new => assigned|
|2018-12-07 15:51||mmichalek||Assigned To||=> mmichalek|
|2018-12-07 15:54||mmichalek||Status||assigned => resolved|
|2018-12-07 15:54||mmichalek||Resolution||open => fixed|
|2018-12-07 15:54||mmichalek||Fixed in Version||=> 3.9.16|
|2018-12-07 16:00||mmichalek||Changeset attached||=> SymmetricDS 3.9 967f7dd0|