Implications of using SELECT *

Generally, you should use SELECT * only when you want to select all fields. Otherwise, specify the specific fields that you want to view.

Question: What are the implications of using SELECT * ?

Answer: Generally, you should select only the fields you need because IMS is sensitive to the number of fields selected. Use SELECT * only when you are sure you want to select all fields, except hidden fields.