Author: athimel Date: 2014-08-08 18:25:41 +0200 (Fri, 08 Aug 2014) New Revision: 510 Url: http://forge.codelutin.com/projects/faxtomail/repository/revisions/510 Log: Add a few indexes Added: trunk/faxtomail-persistence/src/main/resources/important-indexes.sql Added: trunk/faxtomail-persistence/src/main/resources/important-indexes.sql =================================================================== --- trunk/faxtomail-persistence/src/main/resources/important-indexes.sql (rev 0) +++ trunk/faxtomail-persistence/src/main/resources/important-indexes.sql 2014-08-08 16:25:41 UTC (rev 510) @@ -0,0 +1,25 @@ +CREATE INDEX email_receptionDate_idx ON email (receptionDate ASC); +CREATE INDEX email_archiveDate_idx ON email (archiveDate NULLS FIRST); +CREATE INDEX email_mailFolder_idx ON email (mailFolder); +CREATE INDEX email_demandStatus_idx ON email (demandStatus); + +CREATE INDEX email_takenBy_idx ON email(takenBy); +CREATE INDEX email_client_idx ON email(client); +--CREATE INDEX email_emailGroup_idx ON email(emailGroup); +CREATE INDEX email_etatAttente_idx ON email(etatAttente); +CREATE INDEX email_priority_idx ON email(priority); +CREATE INDEX email_demandType_idx ON email (demandType); + +CREATE INDEX demandType_fields_OWNER_idx ON demandType_fields (OWNER); +--CREATE INDEX rangeRow_email_idx ON rangeRow(email); +CREATE INDEX rangeRow_range_idx ON rangeRow(range); +--CREATE INDEX history_email_idx ON history(email); +CREATE INDEX history_faxToMailUser_idx ON history(faxToMailUser); +CREATE INDEX history_fields_OWNER_idx ON history_fields(OWNER); +--CREATE INDEX reply_email_idx ON reply(email); +--CREATE INDEX attachment_email_idx ON attachment(email); + + +CREATE INDEX mailfolder_readrightusers_readRightUsers_idx ON mailfolder_readrightusers(readRightUsers); +CREATE INDEX mailfolder_readrightgroups_readRightGroups_idx ON mailfolder_readrightgroups(readRightGroups); +