Several things. Firstly introduced some efftive from/to fields so that future records could be entered. Second removed a whole bunch of cursors. Third new indexes. Fourth lots and lots of temp tables. Fifth proper table joins so we could make use of statistics. Sixth. Introduced some config and aggregator tables.
Was an interesting project.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Did you optimize query or something ?
Several things. Firstly introduced some efftive from/to fields so that future records could be entered. Second removed a whole bunch of cursors. Third new indexes. Fourth lots and lots of temp tables. Fifth proper table joins so we could make use of statistics. Sixth. Introduced some config and aggregator tables.
Was an interesting project.