RE: [PATCH] Added index on expirytime and destinatioinid to avoid full tables scans. Might be a good idea for other rdbms, too
"Tim Anderson" <[email protected]>
| Newsgroups | gmane.comp.java.openjms.devel |
|---|---|
| Message-ID | <[email protected]> |
Raised as bug #872947: https://sourceforge.net/tracker/?func=detail&atid=474136&aid=872947&group_id =54559 -Tim > -----Original Message----- > From: openjms-developer-admin-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > [mailto:openjms-developer-admin-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org]On Behalf Of > Michael Jaszczyk > Sent: Monday, 5 January 2004 8:26 PM > To: openjms-developer-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > Subject: [openjms-developer] [PATCH] Added index on expirytime and > destinatioinid to avoid full tables scans. Might be a good idea for > other rdbms, too > > > > -- > 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/> > > ------------------------------------------------------- This SF.net email is sponsored by: Perforce Software. Perforce is the Fast Software Configuration Management System offering advanced branching capabilities and atomic changes on 50+ platforms. Free Eval! http://www.perforce.com/perforce/loadprog.html