What are the advantages of using CASE statement?
Combines multiple scans
Reduce number of calls to the database
Performs many small scans as compared to one large scan
Makes more smaller calls to the database as compared to one large call