From e6450df9c4bdd0e1b2133a455930f02c9faa0fbc Mon Sep 17 00:00:00 2001 From: Shocker Date: Mon, 6 Sep 2010 01:38:50 +0300 Subject: DB-Schema/Characters: Add indexes for some columns used in JOINs in the core --HG-- branch : trunk --- sql/updates/9792_characters_groups.sql | 1 + sql/updates/9792_characters_instance.sql | 1 + sql/updates/9792_characters_instance_reset.sql | 1 + 3 files changed, 3 insertions(+) create mode 100644 sql/updates/9792_characters_groups.sql create mode 100644 sql/updates/9792_characters_instance.sql create mode 100644 sql/updates/9792_characters_instance_reset.sql (limited to 'sql/updates') diff --git a/sql/updates/9792_characters_groups.sql b/sql/updates/9792_characters_groups.sql new file mode 100644 index 00000000000..940875d217a --- /dev/null +++ b/sql/updates/9792_characters_groups.sql @@ -0,0 +1 @@ +ALTER TABLE `groups` ADD INDEX ( `leaderGuid` ); diff --git a/sql/updates/9792_characters_instance.sql b/sql/updates/9792_characters_instance.sql new file mode 100644 index 00000000000..0571b1c8953 --- /dev/null +++ b/sql/updates/9792_characters_instance.sql @@ -0,0 +1 @@ +ALTER TABLE `instance` ADD INDEX ( `difficulty` ); diff --git a/sql/updates/9792_characters_instance_reset.sql b/sql/updates/9792_characters_instance_reset.sql new file mode 100644 index 00000000000..f5d21b33951 --- /dev/null +++ b/sql/updates/9792_characters_instance_reset.sql @@ -0,0 +1 @@ +ALTER TABLE `instance_reset` ADD INDEX ( `difficulty` ); -- cgit v1.2.3