Questão 39 – Tecnologia da Informação – FGV 2023 – Controladoria-Geral do Estado de Santa Catarina (Auditor do Estado)

CREATE NONCLUSTERED INDEX st_tdate_ix1 ON salestransaction (tdate)

GO

CREATE UNIQUE INDEX st_tdate_ix1 ON salestransaction (tdate, customerid)

GO

CREATE NONCLUSTERED INDEX st_tdate_ix1 ON salestransaction (tdate)INCLUDE ([customerid])

GO

CREATE CLUSTERED INDEX st_tdate_ix1 ON salestransaction (tdate)INCLUDE ([customerid])

GO

CREATE PRIMARY XML INDEX st_tdate_ix1 ON salestransaction (tdate, customerid) WITH (XML_COMPRESSION = ON);