steve4king
IS-IT--Management
Maintenance on an old program:
No candidate keys, but the candidate key for this file would be:
tranid char(7) + tranline number(4,0)
I need to add an index to speed a routine that looks for missing rows in a mirror table.
Currently the semi applicable index is:
tranid + DTOS(date)
Just adding an index to "tranline" sped up the process 10x.. but I think there is room for more speed.
I'm curious what the impact to writes(or something else I might be overlooking) might be if I were to add an index as such:
tranid + alltrim(str(line,4,0))
Unfortunately, unlike a true SQL database, I can't just index on both without a cast.. right?
-Stephen
No candidate keys, but the candidate key for this file would be:
tranid char(7) + tranline number(4,0)
I need to add an index to speed a routine that looks for missing rows in a mirror table.
Currently the semi applicable index is:
tranid + DTOS(date)
Just adding an index to "tranline" sped up the process 10x.. but I think there is room for more speed.
I'm curious what the impact to writes(or something else I might be overlooking) might be if I were to add an index as such:
tranid + alltrim(str(line,4,0))
Unfortunately, unlike a true SQL database, I can't just index on both without a cast.. right?
-Stephen