search

PNHP / COA_Tools

1 stars 1 forks source link

from michele: missing index #72

Closed ChristopherTracey closed 1 year ago

ChristopherTracey commented 4 years ago

Missing index applied for lu_sgcnXpu_all : CREATE INDEX maindex ON lu_sgcnXpu_all (unique_id, ELSeason). Need to do this automatically so we don't forget

memoore commented 1 year ago

This was occurring because of later error checking and reformatting/resaving of the lu_sgcnXpu_all table. Rearranged scripts so that indexes are the final script run and this should solve the issue.