Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
None
-
None
Description
When moving from the trafodion_beta 0.6.4 release to the Trafodion 0.7.0 (v40174) and RC4 (v40719) releases, the time to prepare SQL queries in OpenCart has significantly increased.
Attached is an example query demonstrating a lengthy compilation.
Update statistics had been previously run on every column against all OpenCart tables.
We also ensured that seapilot was disabled.