Index: branches/RC/core/install/install_schema.sql =================================================================== diff -u -r11354 -r11356 --- branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 11354) +++ branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 11356) @@ -828,6 +828,7 @@ Indices bigint(20) NOT NULL default '0', SearchType int(11) NOT NULL default '0', PRIMARY KEY (SearchLogId), + KEY Keyword (Keyword), KEY SearchType (SearchType) ); Index: branches/RC/core/install/upgrades.sql =================================================================== diff -u -r11354 -r11356 --- branches/RC/core/install/upgrades.sql (.../upgrades.sql) (revision 11354) +++ branches/RC/core/install/upgrades.sql (.../upgrades.sql) (revision 11356) @@ -998,3 +998,4 @@ INSERT INTO ConfigurationValues VALUES (DEFAULT, 'MailingListSendPerStep', 10, 'In-Portal', 'in-portal:configure_general'); ALTER TABLE Events ADD INDEX (Event); +ALTER TABLE SearchLog ADD INDEX (Keyword); \ No newline at end of file