Schema Changes: 2.10.5
Upgrade: 2.10.4 → 2.10.5
This release applied 1 migration(s) to the database schema.
| ID | Type | Description |
|---|---|---|
schema |
indexes for alhr queries |
Migration Details
981 — indexes for alhr queries
Type: schema
View SQL
CREATE INDEX hold_request_copy_capture_time_idx ON action.hold_request (current_copy,capture_time);
CREATE INDEX hold_request_open_captured_shelf_lib_idx ON action.hold_request (current_shelf_lib) WHERE capture_time IS NOT NULL AND fulfillment_time IS NULL AND (pickup_lib <> current_shelf_lib);