Wie sieht's mit folgender Ergaenzung/Korrektur aus?
Zusaetzliche Indizes, um die Zugriffe zu beschleunigen.
Index: scheme.sql
===================================================================
RCS file: /var/cvs/ltev/ltp/scheme.sql,v
retrieving revision 1.22
diff -u -r1.22 scheme.sql
--- scheme.sql 6 May 2002 11:58:19 -0000 1.22
+++ scheme.sql 6 May 2002 12:51:37 -0000
@@ -221,6 +221,8 @@
comment TEXT
);
+CREATE INDEX "availability_name" on "availability" using btree ( "name" );
+
CREATE TABLE job (
id SERIAL NOT NULL,
title TEXT NOT NULL,
@@ -230,6 +232,7 @@
comment TEXT
);
+CREATE UNIQUE INDEX "job_id" on "job" using btree ( "id" );
CREATE UNIQUE INDEX "job_title" on "job" using btree ( "title" );
CREATE TABLE jobfragment (
@@ -242,6 +245,8 @@
comment TEXT
);
+CREATE UNIQUE INDEX "jobfragment_id" on "jobfragment" using btree ( "id" );
+
CREATE TABLE assignment (
id INT4 references jobfragment(id),
person TEXT references person(name),
@@ -249,3 +254,5 @@
endtime timestamp NOT NULL
);
+CREATE INDEX "assignment_id" on "assignment" using btree ( "id" );
+CREATE INDEX "assignment_person" on "assignment" using btree ( "person" );
Gruesse,
Joey
-- All language designers are arrogant. Goes with the territory... -- Larry Wall
This archive was generated by hypermail 2.1.3 : Mon May 06 2002 - 15:42:33 CEST