Permalink
Browse files

added indexes on CPR tables

  • Loading branch information...
1 parent 20fd344 commit 6af0aaa83d93f8006170cb40a62e4c28cc7585c6 Kjeld Froberg committed Jun 19, 2012
Showing with 3 additions and 2 deletions.
  1. +3 −2 db/schema.sql
View
@@ -777,7 +777,7 @@ CREATE TABLE Person (
ValidTo DATETIME NOT NULL,
INDEX (PersonPID, ModifiedDate),
- INDEX (CPR, ValidTo, ValidFrom)
+ INDEX (CPR, ValidTo, ValidFrom, Fornavn, Mellemnavn, Efternavn, Foedselsdato)
) ENGINE=InnoDB COLLATE=utf8_bin;
@@ -789,7 +789,8 @@ CREATE TABLE Person (
CREATE TABLE ChangesToCPR (
CPR CHAR(10) PRIMARY KEY,
- ModifiedDate TIMESTAMP NOT NULL
+ ModifiedDate TIMESTAMP NOT NULL,
+ INDEX (ModifiedDate)
);

0 comments on commit 6af0aaa

Please sign in to comment.