#75 Index exiryTime, destinationId to avoid full table scans

[Tim Anderson]

Extract from mail from Michael Jaszczyk
<mjaszczyk@pi...>:
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.

[Tim Anderson]

[Tim Anderson]

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

[Michael Jaszczyk]

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

[Tim Anderson]

Logged In: YES
user_id=557161

The change to create_oracle.sql has been applied as per
request 964261.
However, similar changes should also be applied to each of
the other databases, so leaving this request open.