Index: trunk/dbconfig/changes.txt
===================================================================
--- trunk/dbconfig/changes.txt	(revision 27763)
+++ trunk/dbconfig/changes.txt	(revision 27764)
@@ -1592,6 +1592,8 @@
 ALTER TABLE pstampDependent CHANGE COLUMN no_magic need_magic TINYINT;
 
-ALTER TABLE magicDSRun ADD KEY (stage);
-ALTER TABLE magicDSRun ADD KEY (stage_id);
-
-
+ALTER TABLE magicDSRun ADD KEY(stage);
+ALTER TABLE magicDSRun ADD KEY(stage_id);
+
+ALTER TABLE distRun ADD KEY(stage), ADD KEY(stage_id), ADD KEY(magic_ds_id), ADD KEY(fault), ADD KEY(data_group);
+ALTER TABLE distTarget ADD KEY(stage), ADD KEY(dist_group), ADD KEY(filter), ADD KEY(state);
+
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 27763)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 27764)
@@ -1345,4 +1345,8 @@
     comment     VARCHAR(255),
     PRIMARY KEY(target_id),
+    KEY(stage),
+    KEY(dist_group),
+    KEY(filter),
+    KEY(state),
     CONSTRAINT UNIQUE (dist_group, filter, stage, clean)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1368,4 +1372,9 @@
     KEY(state),
     KEY(label),
+    KEY(stage),
+    KEY(stage_id),
+    KEY(magic_ds_id),
+    KEY(fault),
+    KEY(data_group),
     FOREIGN KEY(target_id) REFERENCES distTarget(target_id)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;