Author: eallen
Date: 2008-12-04 14:50:51 -0500 (Thu, 04 Dec 2008)
New Revision: 2925
Modified:
mgmt/trunk/mint/sql/indexes.sql
Log:
Adding index on slot.name to improve query performance
Modified: mgmt/trunk/mint/sql/indexes.sql
===================================================================
--- mgmt/trunk/mint/sql/indexes.sql 2008-12-04 19:42:44 UTC (rev 2924)
+++ mgmt/trunk/mint/sql/indexes.sql 2008-12-04 19:50:51 UTC (rev 2925)
@@ -5,3 +5,5 @@
create index queue_stats_queue_id_idx on queue_stats (queue_id);
create index exchange_stats_exchange_id_idx on exchange_stats (exchange_id);
create index client_stats_client_id_idx on client_connection_stats
(client_connection_id);
+
+create index slot_name_idx on slot (name);