@George.Palacios I see now, why you asked about queries. I should specify that I don't always want a seek and I understand that a scan is better in some cases (otherwise why would be have it). The table contains about 60GB of data due to row size (several million) multiplied by the
varchar(MAX)
(which contains strings that are 16000+ characters long). Before inserting into the table, a scan is done to ensure no duplicates are insterted (matching on
Header
for elimination and on
FullVariables
). Then the table is joined in several views on the
ID
field where the seeks are desired. —
dev 2 mins ago