Monthly Archives: May 2016

Improving the performance of functions

By | May 15, 2016

Recently I had to employ functions to perform a kind of name resolution on a column within the database. The database had a user table with usr_name and usr_id and then all other FK tables used usr_id . Within the procedures we could naturally do joins to fetch the username but there were many other… Read More »