We need to determine what indexes we want SystemManagerBean to periodically reindex on Oracle. It currently reindexes these: private final String[] ORA_INDEXES = { "RHQ_MEAS_DATA_1H_ID_TIME_PK", "RHQ_MEAS_DATA_6H_ID_TIME_PK", "RHQ_MEAS_DATA_1D_ID_TIME_PK", "RHQ_MEAS_BASELINE_CTIME_IDX", "RHQ_MEAS_DATA_TRAIT_ID_TIME_PK", "RHQ_MEASUREMENT_OOB_IDX" };
With mazz to investigate if any more need to be added.
we need to do more performance testing to understand what, if anything else, has an access/insertion policy that necessitates adding them to the re-index list. but this won't happen until after 1.1.0
this has been here for a while, has been pushed way out - so clearly, it isn't critical :) moving to "major"
unassigning - leave this for future work to be done
Update this page when we decide what to do: http://support.rhq-project.org/display/RHQ/Design-AllDBTables
there may be nothing we have to do for this - but we should do a quick check to see if we need to reindex others
if we end up getting our performance testing hardware back before 1.2 release, there are other bigger fish to fry than this - namely the performance of the cluster nav tree. plus, we've been operating with the original index list for nearly a year now, so if things were really bad one would hope those issues would have shown up by now.
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-60
relying on perf test team to make these recommendations