[PATCH] Added index on expirytime and destinatioinid to avoid full tables scans. Might be a good idea for other rdbms, too
Michael Jaszczyk <[email protected]>
| Newsgroups | gmane.comp.java.openjms.devel |
|---|---|
| Message-ID | <[email protected]> |
-- PIRONET NDH Michael Jaszczyk - Director Software Maarweg 149 - 161, 50825 Cologne - Germany Phone: +49 (0)221 770 1720 - Fax: +49 (0)221 770 1005 <mailto:[email protected]> - <http://www.pironet-ndh.com/>
create_oracle.patch
(text/plain, 580 B)
Index: create_oracle.sql =================================================================== RCS file: /cvsroot/openjms/openjms/src/config/db/create_oracle.sql,v retrieving revision 1.2 diff -u -w -i -b -r1.2 create_oracle.sql --- create_oracle.sql 23 Oct 2003 13:42:47 -0000 1.2 +++ create_oracle.sql 5 Jan 2004 09:22:54 -0000 @@ -32,6 +32,10 @@ messageBlob LONG raw not null ); create index messages_pk on messages(messageId); +create index messages_x1 on messages( + EXPIRYTIME, + DESTINATIONID +); DROP TABLE message_handles; CREATE TABLE message_handles (