Created
April 11, 2020 20:47
-
-
Save aboglioli/dd5bed76dbd9e58065e092fa666aba82 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ALTER TABLE `dimHora` CHANGE `id_hora` `id_hora` VARCHAR(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL; | |
CREATE INDEX princ ON dimBase(id_base); | |
CREATE INDEX princ ON dimCodigo(id_codigo); | |
CREATE INDEX princ ON dimDesenlace(id_desenlace); | |
CREATE INDEX princ ON dimHora(id_hora); | |
CREATE INDEX princ ON dimInstitucion(id_institucion); | |
CREATE INDEX princ ON dimMovil(id_movil); | |
CREATE INDEX princ ON dimTiempo(id_fecha); | |
CREATE INDEX princ ON dimZona(id_zona); | |
CREATE INDEX princ ON factDespacho(id_fecha, id_hora, id_zona, id_codigo, id_movil, id_base, id_institucion, id_desenlace); | |
CREATE INDEX princ ON factIncidente(id_fecha, id_hora, id_zona, id_codigo); | |
-- ALTER TABLE dimBase ADD INDEX (id_base); | |
-- ALTER TABLE dimCodigo ADD INDEX (id_codigo); | |
-- ALTER TABLE dimDesenlace ADD INDEX (id_desenlace); | |
-- ALTER TABLE dimHora ADD INDEX (id_hora); | |
-- ALTER TABLE dimInstitucion ADD INDEX (id_institucion); | |
-- ALTER TABLE dimMovil ADD INDEX (id_movil); | |
-- ALTER TABLE dimTiempo ADD INDEX (id_fecha); | |
-- ALTER TABLE dimZona ADD INDEX (id_zona); | |
-- | |
-- ALTER TABLE factDespacho ADD INDEX (id_fecha, id_hora, id_zona, id_codigo, id_movil, id_base, id_institucion, id_desenlace); | |
-- ALTER TABLE factIncidente ADD INDEX (id_fecha, id_hora, id_zona, id_codigo); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE INDEX princ ON base(id); | |
CREATE INDEX princ ON codigo(id); | |
CREATE INDEX princ ON desenlace(id); | |
CREATE INDEX princ ON domicilio(id); | |
CREATE INDEX princ ON institucion(id); | |
CREATE INDEX princ ON localidad(id); | |
CREATE INDEX princ ON motivollamado(codigo); | |
CREATE INDEX princ ON movil(id); | |
CREATE INDEX princ ON idsZona(id); | |
CREATE INDEX princ ON idsCodigo(id); | |
CREATE INDEX princ ON idsMovil(id); | |
CREATE INDEX princ ON idsBase(id); | |
CREATE INDEX princ ON idsInstitucion(id); | |
CREATE INDEX princ ON idsDesenlace(id); | |
CREATE INDEX princ ON despacho(id, recepcion_id, movil_id, Base_id, desenlace_id, institucionderiva_id); | |
CREATE INDEX princ ON recepcion(id); | |
-- ALTER TABLE base ADD INDEX (id); | |
-- ALTER TABLE codigo ADD INDEX (id); | |
-- ALTER TABLE desenlace ADD INDEX (id); | |
-- ALTER TABLE domicilio ADD INDEX (id); | |
-- ALTER TABLE institucion ADD INDEX (id); | |
-- ALTER TABLE localidad ADD INDEX (id); | |
-- ALTER TABLE motivollamado ADD INDEX (codigo); | |
-- ALTER TABLE movil ADD INDEX (id); | |
-- ALTER TABLE recepcion ADD INDEX (id); | |
-- | |
-- ALTER TABLE idsZona ADD INDEX (id); | |
-- ALTER TABLE idsCodigo ADD INDEX (id); | |
-- ALTER TABLE idsMovil ADD INDEX (id); | |
-- ALTER TABLE idsBase ADD INDEX (id); | |
-- ALTER TABLE idsInstitucion ADD INDEX (id); | |
-- ALTER TABLE idsDesenlace ADD INDEX (id); | |
-- | |
-- ALTER TABLE despacho ADD INDEX (id, recepcion_id, movil_id, Base_id, desenlace_id, institucionderiva_id); | |
-- ALTER TABLE recepcion ADD INDEX (id); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment