Add a new column for root_namespace_id in project_statistics
Utilization Group: Maintenance Template
Description
Currently the query to get ProjectStatistics from RootNamespace has to join multiple tables to get the data. For big namespaces that is a problem, and results in queries taking way longer than allowed.
As part of the fix, we are adding root_namespace_id in the project_statisitcs table. As part of this issue we need to:
- Add new column in project_statisitcs table to save root_namespace_id for the corresponding project_statistics.
Acceptance Criteria
- Add new column in the table, for starters it is nullable
- Add index on the column
Technical Requirements
Impact Assessment
Rationale: &11215 (comment 1512073183)
Edited by Suraj Tripathi