Details
-
Type:
Improvement
-
Status: Resolved
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Sustaining
-
Fix Version/s: Sustaining
-
Component/s: Performance Reports
-
Labels:
-
Environment:
Staging
Description
DB Maintenance script to add partitions up to 2 years in three pixel tables under 'spike_v2' database.
Affected tables are:
spike_v2.waypointLog
spike_v2.waypointConversionLog
spike_v2.waypointLogLastPaidHit
Attached sql script and rollback script.
Test cases can be found at:
Test Link\ADMAX\Sustaining\DB Maintenance Script
