In some cases, performance issues can arise with SELECT statements. The issue is that number of rows tends to grow rapidly as more tables are joined, as result set is de-normalized and contains a lot ...