[vhffs-dev] [923] Add indexes on dates fields

[subversion@xxxxxxxxxxxxx]

Revision: 923
Author:   gradator
Date:     2007-09-14 02:16:42 +0000 (Fri, 14 Sep 2007)

Log Message:
-----------
Add indexes on dates fields

Modified Paths:
--------------
    trunk/vhffs-backend/src/pgsql/initdb.sql.in


Modified: trunk/vhffs-backend/src/pgsql/initdb.sql.in
===================================================================
--- trunk/vhffs-backend/src/pgsql/initdb.sql.in	2007-09-14 02:04:13 UTC (rev 922)
+++ trunk/vhffs-backend/src/pgsql/initdb.sql.in	2007-09-14 02:16:42 UTC (rev 923)
@@ -320,8 +320,11 @@
 CREATE INDEX idx_vhffs_pgsql_object_id ON vhffs_pgsql(object_id);
 CREATE INDEX idx_vhffs_repository_object_id ON vhffs_repository(object_id);
 CREATE INDEX idx_vhffs_svn_object_id ON vhffs_svn(object_id);
+-- add index on dates, it is used to search old object, ...
+CREATE INDEX idx_vhffs_object_date_creation ON vhffs_object(date_creation);
+CREATE INDEX idx_vhffs_history_date ON vhffs_history(date);
+CREATE INDEX idx_vhffs_mailings_date ON vhffs_mailings(date);
 
-
 /****** Non primary key constraints.
       Defining foreign keys here allow to create tables in any order.
 *******/