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(a)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>
Show replies by date