Skip to content
Snippets Groups Projects

added indexes for review and store_inventory

Merged Elias Messner requested to merge feature/indexes into dev
1 file
+ 5
1
Compare changes
  • Side-by-side
  • Inline
+ 5
1
@@ -90,4 +90,8 @@ CREATE CONSTRAINT TRIGGER check_exists_as_subtype
ON product
DEFERRABLE INITIALLY DEFERRED
FOR EACH ROW
EXECUTE PROCEDURE check_exists_as_subtype();
\ No newline at end of file
EXECUTE PROCEDURE check_exists_as_subtype();
CREATE INDEX ON review (customer);
CREATE INDEX ON store_inventory (store_name, store_street, store_zip);
\ No newline at end of file
Loading