File: bdgp-indexes.sql

package info (click to toggle)
libchado-perl 1.31-7
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 44,728 kB
  • sloc: sql: 282,721; xml: 192,553; perl: 25,524; sh: 102; python: 73; makefile: 57
file content (10 lines) | stat: -rw-r--r-- 474 bytes parent folder | download | duplicates (6) 
1
2
3
4
5
6
7
8
9
10
 
---**********************************************************
--- depends on featureloc_idx3 index
--- make query by range faster
---**********************************************************

CLUSTER featureloc_idx3 on featureloc;

---unique index/constraint(?) (subject_id, object_id) is not adequate
ALTER TABLE cvtermpath DROP CONSTRAINT cvtermpath_subject_id_key;
CREATE UNIQUE INDEX cvtermpath_subject_id_key ON cvtermpath(subject_id, object_id, cv_id, pathdistance);