GLE-Indices-ALB

CREATE INDEX ixadr
  ON alb_f_adressen
  USING btree
  (flurstkennz);

CREATE INDEX ixhw
  ON alb_f_hinweise
  USING btree
  (flurstkennz);

CREATE INDEX ixlag
  ON alb_f_lage
  USING btree
  (flurstkennz);

CREATE INDEX ixtn
  ON alb_f_nutzungen
  USING btree
  (flurstkennz);

CREATE INDEX ixverf
  ON alb_f_verfahren
  USING btree
  (flurstkennz);

CREATE INDEX ixfst
  ON alb_flurstuecke
  USING btree
  (flurstkennz);

CREATE INDEX ixbuch
  ON alb_g_buchungen
  USING btree
  (flurstkennz);

CREATE INDEX ixbuchbz
  ON alb_g_buchungen
  USING btree
  (bezirk);

CREATE INDEX ixeig
  ON alb_g_eigentuemer
  USING btree
  (bezirk);

CREATE INDEX ixgst
  ON alb_g_grundstuecke
  USING btree
  (bezirk);

CREATE INDEX ixname
  ON alb_g_namen
  USING btree
  (lfd_nr_name);

CREATE INDEX ixgb
  ON alb_grundbuecher
  USING btree
  (bezirk);