Index: branches/RC/core/install/install_schema.sql
===================================================================
diff -u -r10294 -r10316
--- branches/RC/core/install/install_schema.sql	(.../install_schema.sql)	(revision 10294)
+++ branches/RC/core/install/install_schema.sql	(.../install_schema.sql)	(revision 10316)
@@ -33,7 +33,11 @@
   OnGeneralTab tinyint(4) NOT NULL default '0',
   IsSystem tinyint(3) unsigned NOT NULL default '0',
   PRIMARY KEY  (CustomFieldId),
-  KEY Type (Type)
+  KEY Type (Type),
+  KEY MultiLingual (MultiLingual),
+  KEY DisplayOrder (DisplayOrder),
+  KEY OnGeneralTab (OnGeneralTab),
+  KEY IsSystem (IsSystem)
 );
 
 CREATE TABLE ConfigurationAdmin (
@@ -46,7 +50,10 @@
   DisplayOrder double NOT NULL default '0',
   GroupDisplayOrder double NOT NULL default '0',
   Install int(11) NOT NULL default '1',
-  PRIMARY KEY  (VariableName)
+  PRIMARY KEY  (VariableName),
+  KEY DisplayOrder (DisplayOrder),
+  KEY GroupDisplayOrder (GroupDisplayOrder),
+  KEY Install (Install)
 );
 
 CREATE TABLE ConfigurationValues (
@@ -86,6 +93,8 @@
 CREATE TABLE EmailSubscribers (
   EmailMessageId int(11) NOT NULL default '0',
   PortalUserId int(11) NOT NULL default '0'
+  KEY EmailMessageId (EmailMessageId),
+  KEY PortalUserId (PortalUserId)
 );
 
 CREATE TABLE Events (
@@ -97,7 +106,9 @@
   Module varchar(40) NOT NULL default '',
   Description varchar(255) NOT NULL default '',
   Type int(11) NOT NULL default '0',
-  PRIMARY KEY  (EventId)
+  PRIMARY KEY  (EventId),
+  KEY Type (Type),
+  KEY Enabled (Enabled)
 );
 
 CREATE TABLE IdGenerator (
@@ -122,6 +133,10 @@
   `Charset` varchar(20) NOT NULL default '',
   UnitSystem tinyint(4) NOT NULL default '1',
   PRIMARY KEY  (LanguageId)
+  KEY Enabled (Enabled),
+  KEY PrimaryLang (PrimaryLang),
+  KEY AdminInterfaceLang (AdminInterfaceLang),
+  KEY Priority (Priority)
 );
 
 CREATE TABLE Modules (
@@ -134,7 +149,9 @@
   TemplatePath varchar(255) NOT NULL default '',
   RootCat int(11) NOT NULL default '0',
   BuildDate int(10) unsigned default NULL,
-  PRIMARY KEY  (`Name`)
+  PRIMARY KEY  (`Name`),
+  KEY Loaded (Loaded),
+  KEY LoadOrder (LoadOrder)
 );
 
 CREATE TABLE PersistantSessionData (
@@ -144,7 +161,9 @@
   VariableValue text NOT NULL,
   PRIMARY KEY  (VariableId),
   KEY UserId (PortalUserId),
-  KEY VariableName (VariableName)
+  KEY VariableName (VariableName),
+  KEY VariableName (Loaded),
+  KEY VariableName (LoadOrder)
 );
 
 CREATE TABLE Phrase (
@@ -168,7 +187,10 @@
   ThemeId int(11) NOT NULL default '0',
   StylesheetId int(10) unsigned NOT NULL default '0',
   ConfigVariables text,
-  PRIMARY KEY  (Template)
+  PRIMARY KEY  (Template),
+  KEY CacheDate (CacheDate),
+  KEY ThemeId (ThemeId),
+  KEY StylesheetId (StylesheetId)
 );
 
 CREATE TABLE PortalGroup (
@@ -184,7 +206,8 @@
   UNIQUE KEY Name (Name),
   UNIQUE KEY ResourceId (ResourceId),
   KEY Personal (Personal),
-  KEY Enabled (Enabled)
+  KEY Enabled (Enabled),
+  KEY CreatedOn (CreatedOn)
 );
 
 CREATE TABLE PortalUser (
@@ -218,7 +241,10 @@
   PRIMARY KEY  (PortalUserId),
   UNIQUE KEY ResourceId (ResourceId),
   UNIQUE KEY Login (Login),
-  KEY CreatedOn (CreatedOn)
+  KEY CreatedOn (CreatedOn),
+  KEY Status (Status),
+  KEY Modified (Modified),
+  KEY IsBanned (IsBanned)
 );
 
 CREATE TABLE PortalUserCustomData (
@@ -245,7 +271,10 @@
   PrimaryTheme int(11) NOT NULL default '0',
   CacheTimeout int(11) NOT NULL default '0',
   StylesheetId int(10) unsigned NOT NULL default '0',
-  PRIMARY KEY  (ThemeId)
+  PRIMARY KEY  (ThemeId),
+  KEY Enabled (Enabled),
+  KEY StylesheetId (StylesheetId),
+  KEY PrimaryTheme (PrimaryTheme)
 );
 
 CREATE TABLE ThemeFiles (
@@ -271,7 +300,9 @@
   ExpirationReminderSent tinyint(4) NOT NULL default '0',
   PRIMARY KEY  (PortalUserId,GroupId),
   KEY GroupId (GroupId),
-  KEY PrimaryGroup (PrimaryGroup)
+  KEY PrimaryGroup (PrimaryGroup),
+  KEY MembershipExpires (MembershipExpires),
+  KEY ExpirationReminderSent (ExpirationReminderSent)
 );
 
 CREATE TABLE UserSession (
@@ -300,7 +331,8 @@
   `timestamp` bigint(20) default '0',
   event varchar(100) default NULL,
   EventParams text NOT NULL,
-  PRIMARY KEY  (EmailLogId)
+  PRIMARY KEY  (EmailLogId),
+  KEY `timestamp` (`timestamp`)
 );
 
 CREATE TABLE Cache (
@@ -319,7 +351,9 @@
   DestName varchar(255) NOT NULL default '',
   DestAbbr char(3) NOT NULL default '',
   DestAbbr2 char(2) default NULL,
-  PRIMARY KEY  (DestId)
+  PRIMARY KEY  (DestId),
+  KEY DestType (DestType),
+  KEY DestParentId (DestParentId)
 );
 
 CREATE TABLE Category (
@@ -386,7 +420,10 @@
   KEY l5_Description (l5_Description(5)),
   KEY TreeLeft (TreeLeft),
   KEY TreeRight (TreeRight),
-  KEY SymLinkCategoryId (SymLinkCategoryId)
+  KEY SymLinkCategoryId (SymLinkCategoryId),
+  KEY Status (Status),
+  KEY CreatedOn (CreatedOn),
+  KEY EditorsPick (EditorsPick)
 );
 
 CREATE TABLE CategoryCustomData (
@@ -425,7 +462,9 @@
   AdvancedCSS text NOT NULL,
   LastCompiled int(10) unsigned NOT NULL default '0',
   Enabled int(11) NOT NULL default '0',
-  PRIMARY KEY  (StylesheetId)
+  PRIMARY KEY  (StylesheetId),
+  KEY Enabled (Enabled),
+  KEY LastCompiled (LastCompiled)
 );
 
 CREATE TABLE PopupSizes (
@@ -447,7 +486,10 @@
   IsClone tinyint(3) unsigned NOT NULL default '0',
   TablesAffected text,
   PRIMARY KEY  (CounterId),
-  UNIQUE KEY Name (Name)
+  UNIQUE KEY Name (Name),
+  KEY IsClone (IsClone),
+  KEY LifeTime (LifeTime),
+  KEY LastCounted (LastCounted)
 );
 
 CREATE TABLE Skins (
@@ -458,7 +500,9 @@
   `Options` text,
   `LastCompiled` int(11) NOT NULL default '0',
   `IsPrimary` int(1) NOT NULL default '0',
-  PRIMARY KEY  (`SkinId`)
+  PRIMARY KEY  (`SkinId`),
+  KEY IsPrimary (IsPrimary),
+  KEY LastCompiled (LastCompiled)
 );
 
 CREATE TABLE ChangeLogs (
@@ -492,5 +536,6 @@
   AffectedItems int(11) NOT NULL default '0',
   PRIMARY KEY  (SessionLogId),
   KEY SessionId (SessionId),
-  KEY `Status` (`Status`)
+  KEY `Status` (`Status`),
+  KEY PortalUserId (PortalUserId)
 );
Index: branches/RC/admin/install/inportal_schema.sql
===================================================================
diff -u -r9598 -r10316
--- branches/RC/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 9598)
+++ branches/RC/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 10316)
@@ -8,7 +8,10 @@
   Priority int(11) NOT NULL default '0',
   Status tinyint(4) NOT NULL default '1',
   ErrorTag varchar(255) default NULL,
-  PRIMARY KEY  (RuleId)
+  PRIMARY KEY  (RuleId),
+  KEY Status (Status),
+  KEY Priority (Priority),
+  KEY ItemType (ItemType)
 )
 
 # --------------------------------------------------------
@@ -33,7 +36,9 @@
   ItemTypeId int(11) NOT NULL default '0',
   Modified int(11) NOT NULL default '0',
   PRIMARY KEY  (FavoriteId),
-  UNIQUE KEY main (PortalUserId,ResourceId)
+  UNIQUE KEY main (PortalUserId,ResourceId),
+  KEY Modified (Modified),
+  KEY ItemTypeId (ItemTypeId)
 )
 
 # --------------------------------------------------------
@@ -55,7 +60,9 @@
   LocalThumb tinyint(4) NOT NULL default '1',
   SameImages tinyint(4) NOT NULL default '1',
   PRIMARY KEY  (ImageId),
-  KEY ResourceId (ResourceId)
+  KEY ResourceId (ResourceId),
+  KEY Enabled (Enabled),
+  KEY Priority (Priority)
 )
 
 # --------------------------------------------------------
@@ -66,7 +73,10 @@
   CreatedOn INT UNSIGNED NULL DEFAULT NULL,
   RatingValue int(11) NOT NULL default '0',
   ItemId int(11) NOT NULL default '0',
-  PRIMARY KEY  (RatingId)
+  PRIMARY KEY  (RatingId),
+  KEY CreatedOn (CreatedOn),
+  KEY ItemId (ItemId),
+  KEY RatingValue (RatingValue)
 )
 
 # --------------------------------------------------------
@@ -85,6 +95,11 @@
   TextFormat int(11) NOT NULL default '0',
   Module varchar(255) NOT NULL default '',
   PRIMARY KEY  (ReviewId)
+  KEY CreatedOn (CreatedOn),
+  KEY ItemId (ItemId),
+  KEY ItemType (ItemType),
+  KEY Priority (Priority),
+  KEY Status (Status)
 )
 
 # --------------------------------------------------------
@@ -120,7 +135,9 @@
   CreatedById int(11) NOT NULL default '-1',
   MimeType varchar(255) NOT NULL default '',
   PRIMARY KEY  (FileId),
-  KEY ResourceId (ResourceId)
+  KEY ResourceId (ResourceId),
+  KEY CreatedOn (CreatedOn),
+  KEY Status (Status)
 )
 
 # --------------------------------------------------------
@@ -136,7 +153,12 @@
   Priority int(11) NOT NULL default '0',
   PRIMARY KEY  (RelationshipId),
   KEY RelSource (SourceId),
-  KEY RelTarget (TargetId)
+  KEY RelTarget (TargetId),
+  KEY `Type` (`Type`),
+  KEY Enabled (Enabled),
+  KEY Priority (Priority),
+  KEY SourceType (SourceType),
+  KEY TargetType (TargetType)
 )
 
 # --------------------------------------------------------
@@ -161,7 +183,12 @@
   ContainsWhere text,
   NotContainsWhere text,
   CustomFieldId int(11) default NULL,
-  PRIMARY KEY  (SearchConfigId)
+  PRIMARY KEY  (SearchConfigId),
+  KEY SimpleSearch (SimpleSearch),
+  KEY AdvancedSearch (AdvancedSearch),
+  KEY DisplayOrder (DisplayOrder),
+  KEY Priority (Priority),
+  KEY CustomFieldId (CustomFieldId)
 )
 
 # --------------------------------------------------------
@@ -171,7 +198,8 @@
   Keyword varchar(255) NOT NULL default '',
   Indices bigint(20) NOT NULL default '0',
   SearchType int(11) NOT NULL default '0',
-  PRIMARY KEY  (SearchLogId)
+  PRIMARY KEY  (SearchLogId),
+  KEY SearchType (SearchType)
 )
 
 # --------------------------------------------------------
@@ -188,7 +216,10 @@
   IPaddress varchar(20) NOT NULL default '',
   Expire INT UNSIGNED NULL DEFAULT NULL,
   PortalUserId int(11) NOT NULL default '0',
-  DataType varchar(20) default NULL
+  DataType varchar(20) default NULL,
+  KEY PortalUserId (PortalUserId),
+  KEY Expire (Expire),
+  KEY ItemResourceId (ItemResourceId)
 )
 
 # --------------------------------------------------------
@@ -201,15 +232,18 @@
   ListLabel varchar(255) NOT NULL default '',
   Priority int(11) NOT NULL default '0',
   AdminSummary int(11) NOT NULL default '0',
-  PRIMARY KEY  (StatItemId)
+  PRIMARY KEY  (StatItemId),
+  KEY AdminSummary (AdminSummary),
+  KEY Priority (Priority)
 )
 
 # --------------------------------------------------------
 
 CREATE TABLE SuggestMail (
   email varchar(255) NOT NULL default '',
   sent INT UNSIGNED NULL DEFAULT NULL,
-  PRIMARY KEY  (email)
+  PRIMARY KEY  (email),
+  KEY sent (sent)
 )
 
 # --------------------------------------------------------
@@ -247,7 +281,8 @@
   DefValue varchar(255) default NULL,
   Description TEXT,
   Required int(11) NOT NULL default '0',
-  PRIMARY KEY  (AttrId)
+  PRIMARY KEY  (AttrId),
+  KEY TagId (TagId)
 )
 
 # --------------------------------------------------------
@@ -262,7 +297,8 @@
   is_requred_fields varchar(255) NOT NULL default '',
   is_enabled tinyint(1) unsigned NOT NULL default '0',
   is_type varchar(10) NOT NULL default '',
-  PRIMARY KEY  (is_id)
+  PRIMARY KEY  (is_id),
+  KEY is_enabled (is_enabled)
 )
 
 # --------------------------------------------------------
@@ -277,7 +313,10 @@
   Type tinyint(4) NOT NULL default '0',
   AdvancedCSS text NOT NULL,
   ParentId int(11) NOT NULL default '0',
-  PRIMARY KEY  (SelectorId)
+  PRIMARY KEY  (SelectorId),
+  KEY StylesheetId (StylesheetId),
+  KEY ParentId (ParentId),
+  KEY `Type` (`Type`)
 )
 
 # --------------------------------------------------------
@@ -291,7 +330,8 @@
   PortalUserId int(11) NOT NULL default '-2',
   PRIMARY KEY  (VisitId),
   KEY PortalUserId (PortalUserId),
-  KEY AffiliateId (AffiliateId)
+  KEY AffiliateId (AffiliateId),
+  KEY VisitDate (VisitDate)
 )
 
 # --------------------------------------------------------
Index: branches/RC/core/install/upgrades.sql
===================================================================
diff -u -r10294 -r10316
--- branches/RC/core/install/upgrades.sql	(.../upgrades.sql)	(revision 10294)
+++ branches/RC/core/install/upgrades.sql	(.../upgrades.sql)	(revision 10316)
@@ -175,7 +175,7 @@
 INSERT INTO ConfigurationAdmin VALUES ('u_ThumbnailImageHeight', 'la_section_ImageSettings', 'la_config_ThumbnailImageHeight', 'text', '', '', 30.03, 0, 0);
 INSERT INTO ConfigurationAdmin VALUES ('u_FullImageWidth', 'la_section_ImageSettings', 'la_config_FullImageWidth', 'text', '', '', 30.04, 0, 0);
 INSERT INTO ConfigurationAdmin VALUES ('u_FullImageHeight', 'la_section_ImageSettings', 'la_config_FullImageHeight', 'text', '', '', 30.05, 0, 0);
-            
+
 INSERT INTO ConfigurationValues VALUES (DEFAULT, 'u_MaxImageCount', 5, 'In-Portal:Users', 'in-portal:configure_users');
 INSERT INTO ConfigurationValues VALUES (DEFAULT, 'u_ThumbnailImageWidth', 120, 'In-Portal:Users', 'in-portal:configure_users');
 INSERT INTO ConfigurationValues VALUES (DEFAULT, 'u_ThumbnailImageHeight', 120, 'In-Portal:Users', 'in-portal:configure_users');
@@ -214,5 +214,26 @@
   AffectedItems int(11) NOT NULL default '0',
   PRIMARY KEY  (SessionLogId),
   KEY SessionId (SessionId),
-  KEY `Status` (`Status`)
-);
\ No newline at end of file
+  KEY `Status` (`Status`),
+  KEY PortalUserId (PortalUserId)
+);
+
+ALTER TABLE CustomField ADD INDEX (MultiLingual), ADD INDEX (DisplayOrder), ADD INDEX (OnGeneralTab), ADD INDEX (IsSystem);
+ALTER TABLE ConfigurationAdmin ADD INDEX (DisplayOrder), ADD INDEX (GroupDisplayOrder), ADD INDEX (Install);
+ALTER TABLE EmailSubscribers ADD INDEX (EmailMessageId), ADD INDEX (PortalUserId);
+ALTER TABLE Events ADD INDEX (`Type`), ADD INDEX (Enabled);
+ALTER TABLE Language ADD INDEX (Enabled), ADD INDEX (PrimaryLang), ADD INDEX (AdminInterfaceLang), ADD INDEX (Priority);
+ALTER TABLE Modules ADD INDEX (Loaded), ADD INDEX (LoadOrder);
+ALTER TABLE PhraseCache ADD INDEX (CacheDate), ADD INDEX (ThemeId), ADD INDEX (StylesheetId);
+ALTER TABLE PortalGroup ADD INDEX (CreatedOn);
+ALTER TABLE PortalUser ADD INDEX (Status), ADD INDEX (Modified), ADD INDEX (dob), ADD INDEX (IsBanned);
+ALTER TABLE Theme ADD INDEX (Enabled), ADD INDEX (StylesheetId), ADD INDEX (PrimaryTheme);
+ALTER TABLE UserGroup ADD INDEX (MembershipExpires), ADD INDEX (ExpirationReminderSent);
+ALTER TABLE EmailLog ADD INDEX (`timestamp`);
+ALTER TABLE StdDestinations ADD INDEX (DestType), ADD INDEX (DestParentId);
+ALTER TABLE Category ADD INDEX (Status), ADD INDEX (CreatedOn), ADD INDEX (EditorsPick);
+ALTER TABLE Stylesheets ADD INDEX (Enabled), ADD INDEX (LastCompiled);
+ALTER TABLE Counters ADD INDEX (IsClone), ADD INDEX (LifeTime), ADD INDEX (LastCounted);
+ALTER TABLE Skins ADD INDEX (IsPrimary), ADD INDEX (LastCompiled);
+
+
Index: branches/RC/core/install/install_data.sql
===================================================================
diff -u -r10315 -r10316
--- branches/RC/core/install/install_data.sql	(.../install_data.sql)	(revision 10315)
+++ branches/RC/core/install/install_data.sql	(.../install_data.sql)	(revision 10316)
@@ -628,3 +628,4 @@
 INSERT INTO ConfigurationAdmin VALUES ('UsePageHitCounter', 'la_Text_Website', 'la_config_UsePageHitCounter', 'checkbox', '', '', 10.24, 0, 0);
 INSERT INTO ConfigurationValues VALUES (DEFAULT, 'UsePageHitCounter', 0, 'In-Portal', 'in-portal:configure_general');
 
+INSERT INTO ConfigurationValues VALUES (DEFAULT, 'PageHitCounter', 0, 'In-Portal', 'in-portal:configure_general');
Index: branches/RC/admin/install/upgrades/inportal_upgrade_v4.3.0.sql
===================================================================
diff -u -r10315 -r10316
--- branches/RC/admin/install/upgrades/inportal_upgrade_v4.3.0.sql	(.../inportal_upgrade_v4.3.0.sql)	(revision 10315)
+++ branches/RC/admin/install/upgrades/inportal_upgrade_v4.3.0.sql	(.../inportal_upgrade_v4.3.0.sql)	(revision 10316)
@@ -25,7 +25,44 @@
 INSERT INTO Counters VALUES (DEFAULT, 'users_online', 'SELECT COUNT(*) FROM <%PREFIX%>UserSession', NULL , NULL , '3600', '0', '|UserSession|');
 
 CREATE TABLE ChangeLogs (ChangeLogId bigint(20) NOT NULL auto_increment, PortalUserId int(11) NOT NULL default '0', SessionLogId int(11) NOT NULL default '0', `Action` tinyint(4) NOT NULL default '0', OccuredOn int(11) NOT NULL default '0', Prefix varchar(255) NOT NULL default '', ItemId bigint(20) NOT NULL default '0', Changes text NOT NULL, MasterPrefix varchar(255) NOT NULL default '', MasterId bigint(20) NOT NULL default '0', PRIMARY KEY  (ChangeLogId), KEY PortalUserId (PortalUserId), KEY SessionLogId (SessionLogId), KEY `Action` (`Action`), KEY OccuredOn (OccuredOn), KEY Prefix (Prefix), KEY MasterPrefix (MasterPrefix));
-CREATE TABLE SessionLogs (SessionLogId bigint(20) NOT NULL auto_increment, PortalUserId int(11) NOT NULL default '0', SessionId int(10) NOT NULL default '0', `Status` tinyint(4) NOT NULL default '1', SessionStart int(11) NOT NULL default '0', SessionEnd int(11) default NULL, IP varchar(15) NOT NULL default '', AffectedItems int(11) NOT NULL default '0', PRIMARY KEY  (SessionLogId), KEY SessionId (SessionId), KEY `Status` (`Status`));
+CREATE TABLE SessionLogs (SessionLogId bigint(20) NOT NULL auto_increment, PortalUserId int(11) NOT NULL default '0', SessionId int(10) NOT NULL default '0', `Status` tinyint(4) NOT NULL default '1', SessionStart int(11) NOT NULL default '0', SessionEnd int(11) default NULL, IP varchar(15) NOT NULL default '', AffectedItems int(11) NOT NULL default '0', PRIMARY KEY  (SessionLogId), KEY SessionId (SessionId), KEY `Status` (`Status`), KEY PortalUserId (PortalUserId));
 
+INSERT INTO ConfigurationValues VALUES (DEFAULT, 'PageHitCounter', 0, 'In-Portal', 'in-portal:configure_general');
+
+ALTER TABLE CustomField ADD INDEX (MultiLingual), ADD INDEX (DisplayOrder), ADD INDEX (OnGeneralTab), ADD INDEX (IsSystem);
+ALTER TABLE ConfigurationAdmin ADD INDEX (DisplayOrder), ADD INDEX (GroupDisplayOrder), ADD INDEX (Install);
+ALTER TABLE EmailSubscribers ADD INDEX (EmailMessageId), ADD INDEX (PortalUserId);
+ALTER TABLE Events ADD INDEX (`Type`), ADD INDEX (Enabled);
+ALTER TABLE Language ADD INDEX (Enabled), ADD INDEX (PrimaryLang), ADD INDEX (AdminInterfaceLang), ADD INDEX (Priority);
+ALTER TABLE Modules ADD INDEX (Loaded), ADD INDEX (LoadOrder);
+ALTER TABLE PhraseCache ADD INDEX (CacheDate), ADD INDEX (ThemeId), ADD INDEX (StylesheetId);
+ALTER TABLE PortalGroup ADD INDEX (CreatedOn);
+ALTER TABLE PortalUser ADD INDEX (Status), ADD INDEX (Modified), ADD INDEX (dob), ADD INDEX (IsBanned);
+ALTER TABLE Theme ADD INDEX (Enabled), ADD INDEX (StylesheetId), ADD INDEX (PrimaryTheme);
+ALTER TABLE UserGroup ADD INDEX (MembershipExpires), ADD INDEX (ExpirationReminderSent);
+ALTER TABLE EmailLog ADD INDEX (`timestamp`);
+ALTER TABLE StdDestinations ADD INDEX (DestType), ADD INDEX (DestParentId);
+ALTER TABLE Category ADD INDEX (Status), ADD INDEX (CreatedOn), ADD INDEX (EditorsPick);
+ALTER TABLE Stylesheets ADD INDEX (Enabled), ADD INDEX (LastCompiled);
+ALTER TABLE Counters ADD INDEX (IsClone), ADD INDEX (LifeTime), ADD INDEX (LastCounted);
+ALTER TABLE Skins ADD INDEX (IsPrimary), ADD INDEX (LastCompiled);
+
+ALTER TABLE BanRules ADD INDEX (Status), ADD INDEX (Priority), ADD INDEX (ItemType);
+ALTER TABLE Favorites ADD INDEX (Modified), ADD INDEX (ItemTypeId);
+ALTER TABLE Images ADD INDEX (Priority), ADD INDEX (Enabled);
+ALTER TABLE ItemRating ADD INDEX (CreatedOn), ADD INDEX (ItemId), ADD INDEX (RatingValue);
+ALTER TABLE ItemReview ADD INDEX (CreatedOn), ADD INDEX (ItemId), ADD INDEX (ItemType), ADD INDEX (Priority), ADD INDEX (Status);
+ALTER TABLE ItemFiles ADD INDEX (CreatedOn), ADD INDEX (Status);
+ALTER TABLE Relationship ADD INDEX (`Type`), ADD INDEX (Enabled), ADD INDEX (Priority), ADD INDEX (SourceType), ADD INDEX (TargetType);
+ALTER TABLE SearchConfig ADD INDEX (SimpleSearch), ADD INDEX (AdvancedSearch), ADD INDEX (DisplayOrder), ADD INDEX (Priority), ADD INDEX (CustomFieldId);
+ALTER TABLE SearchLog ADD INDEX (SearchType);
+ALTER TABLE SpamControl ADD INDEX (PortalUserId), ADD INDEX (Expire), ADD INDEX (ItemResourceId);
+ALTER TABLE StatItem ADD INDEX (AdminSummary), ADD INDEX (Priority);
+ALTER TABLE SuggestMail ADD INDEX (sent);
+ALTER TABLE TagAttributes ADD INDEX (TagId);
+ALTER TABLE ImportScripts ADD INDEX (is_enabled);
+ALTER TABLE StylesheetSelectors ADD INDEX (StylesheetId), ADD INDEX (ParentId), ADD INDEX (`Type`);
+ALTER TABLE Visits ADD INDEX (VisitDate);
+
 UPDATE Modules SET Version = '4.2.3' WHERE Name = 'Core';
 UPDATE Modules SET Version = '4.3.0' WHERE Name = 'In-Portal';
\ No newline at end of file