diff --git a/Repositories/statistics/sql/db.schema.eprintstats.sql b/Repositories/statistics/sql/db.schema.eprintstats.sql
index fbd75a0..a8c7c79 100755
--- a/Repositories/statistics/sql/db.schema.eprintstats.sql
+++ b/Repositories/statistics/sql/db.schema.eprintstats.sql
@@ -44,8 +44,12 @@
 flush privileges;
 
 
+/* NJS 2009-04-29
+   Add indexes to improve query performance. These may become an issue if
+   hit rates are very high (=> many INSERTs).
+*/
 
-
-
+-- This seems to be the most effective (greatest impact).
+create index archiveid_idx on view ( archiveid );