Index: /trunk/dbconfig/changes.txt
===================================================================
--- /trunk/dbconfig/changes.txt	(revision 23952)
+++ /trunk/dbconfig/changes.txt	(revision 23953)
@@ -1085,2 +1085,5 @@
 
 ALTER TABLE diffSkyfile ADD COLUMN deconv_max FLOAT AFTER kernel_yy;
+
+-- This key makes it faster to find the ccd_temp for XY24
+ALTER TABLE rawImfile ADD KEY(dateobs);
Index: /trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- /trunk/ippTools/share/pxadmin_create_tables.sql	(revision 23952)
+++ /trunk/ippTools/share/pxadmin_create_tables.sql	(revision 23953)
@@ -242,4 +242,5 @@
     KEY(raw_image_id),
     KEY(quality),
+    KEY(dateobs),
     UNIQUE KEY(exp_id, tmp_class_id),
     FOREIGN KEY(exp_id, tmp_class_id) REFERENCES newImfile(exp_id, tmp_class_id)