[ openjms-Bugs-872947 ] Index exiryTime, destinationId to avoid full table scans

Bugs item #872947, was opened at 2004-01-08 10:41
Message generated for change (Comment added) made by mjaszczyk
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=872947&group_id=54559

Category: persistence
Group: v0.7.6-rc3
Status: Open
Resolution: None
Priority: 5
Submitted By: Tim Anderson (tanderson)
Assigned to: Tim Anderson (tanderson)
Summary: Index exiryTime, destinationId to avoid full table scans

Initial Comment:
Extract from mail from Michael Jaszczyk 
<mjaszczyk-/[email protected]>: 
http://sourceforge.net/mailarchive/forum.php?
thread_id=3694232&forum_id=11794

Attached patch for create_oracle.sql adds index on 
expirytime and destinatioinid to avoid full tables scans. 
Might be a good idea for other rdbms, too.
 

 


----------------------------------------------------------------------

Comment By: Michael Jaszczyk (mjaszczyk)
Date: 2004-06-01 15:15

Message:
Logged In: YES 
user_id=940611

added a new patch for oracle, which also changes the table 
definitions to use primary keys with the reuqest ID:964261

----------------------------------------------------------------------

Comment By: Tim Anderson (tanderson)
Date: 2004-01-08 14:04

Message:
Logged In: YES 
user_id=557161

Not sure I want to apply this patch before the final 0.7.6 
release as the master database schema 
(src/main/org/exolab/jms/tools/db/schema.xml) should be 
updated first


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=872947&group_id=54559


-------------------------------------------------------
This SF.Net email is sponsored by the new InstallShield X.
From Windows to Linux, servers to mobile, InstallShield X is the one
installation-authoring solution that does it all. Learn more and
evaluate today! http://www.installshield.com/Dev2Dev/0504