ALTER TABLE TBDESPESA_HISTORICO
    ADD DATA COMPUTED BY (cast('01.'||mes||'.'||ano as date));


CREATE INDEX ITBDESPESA_HISTORICO_07
ON TBDESPESA_HISTORICO COMPUTED BY (cast('01.'||mes||'.'||ano as date));

ALTER TABLE TBFAMILIA_FATURAMENTO
    ADD DATA COMPUTED BY (cast('01.'||mes||'.'||ano as date));


CREATE INDEX ITBFAMILIA_FATURAMENTO_02
ON TBFAMILIA_FATURAMENTO COMPUTED BY (cast('01.'||mes||'.'||ano as date));