Side point: "SELECT *" should only be used in EXISTS() clauses (the entire SELECT * FROM is redundant) and ad hoc queries. When writing actual code, specify the columns. Not only does this avoid bugs due to column reordering, catch errors in view changes, and save network bandwidth, it also is self-documenting.