I have a loader application that loads rows into a database with one column in the form: aaa/bbb
The end user will query based on bbb, so to allow an indexed search on bbb we are creating an additional column holding just bbb.
My question is about best practice. Should we do this by editing the loader to send in the additional column directly, or should we use functionality within SQL Server (trigger or calculated field etc) to populate the new row, leaving the functionality of the loader app unchanged?
I feel that the first method is more elegent and easier for all to understand, but the second method is faster to implement and reduces the volume of data flow from loader to database.
Thanks
http://90.212.51.111 domain