DB-Schema/Characters: Add indexes for some columns used in JOINs in the core

--HG--
branch : trunk

4 files changed, 9 insertions, 3 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index a03fbddb23b..dc19205cbd6 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1387,7 +1387,8 @@ CREATE TABLE `groups` (
   `groupType` mediumint(8) unsigned NOT NULL,
   `difficulty` tinyint(3) unsigned NOT NULL default '0',
   `raiddifficulty` int(11) UNSIGNED NOT NULL default '0',
-  PRIMARY KEY  (`guid`)
+  PRIMARY KEY (`guid`),
+  KEY `leaderGuid` (`leaderGuid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -1663,7 +1664,8 @@ CREATE TABLE `instance` (
   `data` longtext,
   PRIMARY KEY  (`id`),
   KEY `map` (`map`),
-  KEY `resettime` (`resettime`)
+  KEY `resettime` (`resettime`),
+  KEY `difficulty` (`difficulty`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -1687,7 +1689,8 @@ CREATE TABLE `instance_reset` (
   `mapid` int(11) unsigned NOT NULL default '0',
   `difficulty` tinyint(1) unsigned NOT NULL default '0',
   `resettime` bigint(40) NOT NULL default '0',
-  PRIMARY KEY  (`mapid`,`difficulty`)
+  PRIMARY KEY (`mapid`,`difficulty`),
+  KEY `difficulty` (`difficulty`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
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` );