From 5ce8396400d7a0f16a013b62c57adae8c1bc034b Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 9 Jul 2012 13:29:16 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 247452ca..1947f40a 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -88,6 +88,7 @@ ALTER TABLE Events ADD INDEX lookuppt ( person_table); --# speeding up lookups. ALTER TABLE Events ADD INDEX lookup_when( person_id, event_id ); +alter table Events add index lookup_event_when (event_when); -- 2.39.2