Project

General

Profile

« Previous | Next » 

Revision 10793

inputs/.TNRS/schema.sql: added covering indexes on foreign keys where needed. this enables rows to be cascadingly deleted without a full table scan.

View differences:

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