Revision 10793
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 434 | 434 |
|
| 435 | 435 |
|
| 436 | 436 |
-- |
| 437 |
-- Name: batch_client_version_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 438 |
-- |
|
| 439 |
|
|
| 440 |
CREATE INDEX batch_client_version_idx ON batch USING btree (client_version); |
|
| 441 |
|
|
| 442 |
|
|
| 443 |
-- |
|
| 437 | 444 |
-- Name: tnrs_score_ok; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 438 | 445 |
-- |
| 439 | 446 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: added covering indexes on foreign keys where needed. this enables rows to be cascadingly deleted without a full table scan.