modules/core/dbutils/pom.xml | 2 +- modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml | 8 ++++++++ 2 files changed, 9 insertions(+), 1 deletion(-)
New commits: commit 15b395b1294158dc65979d3b896e5eca6db421f1 Author: Lukas Krejci lkrejci@redhat.com Date: Thu Dec 16 12:11:25 2010 +0100
BZ 656471 - add index on the timestamp of the RHQ_MEASUREMENT_DATA_NUM_1D table to speed up the data compression
diff --git a/modules/core/dbutils/pom.xml b/modules/core/dbutils/pom.xml index 00053ab..ea159a0 100644 --- a/modules/core/dbutils/pom.xml +++ b/modules/core/dbutils/pom.xml @@ -22,7 +22,7 @@
<properties> <scm.module.path>modules/core/dbutils/</scm.module.path> - <db.schema.version>2.92.3</db.schema.version> + <db.schema.version>2.92.4</db.schema.version> </properties>
<dependencies> diff --git a/modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml b/modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml index 1d29019..48e8f1d 100644 --- a/modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml +++ b/modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml @@ -3129,6 +3129,14 @@ <!-- third, maintain consistency across data model - everywhere else, SUBJECT_NAME is of size 100, make this one 100 too --> <schema-alterColumn table="RHQ_PARTITION_EVENT" column="SUBJECT_NAME" columnType="VARCHAR2" precision="100" /> </schemaSpec> + + <schemaSpec version="2.92.4"> + <schema-directSQL> + <statement desc="Add index on measurement data 1d table timestamp"> + CREATE INDEX RHQ_MEAS_DATA_1D_TIME_IDX ON RHQ_MEASUREMENT_DATA_NUM_1D (time_stamp) + </statement> + </schema-directSQL> + </schemaSpec> </dbupgrade> </target> </project>
rhq-commits@lists.fedorahosted.org